Problem with cross columns

[Ash]

Hi,

I am using Cross table to design my reports. Cross tables seems pretty much complex to me.
I am displaying sales values supplied by suppliers and members for different quarters. I am gettings values by querry from different tables and creating one temporary table, which acts as a datasource to my report.

The report looks like:

Supp Name................Qtr1........................................Qtr2.........................................Qtr3.........................................Qtr4
.................SuppSales....MemberSales...........SuppSales....MemberSales........SuppSales......MemberSales....... SuppSales....MemberSales
aa................100.................200.....................100...............300.........................300.............300.......................400............200
bb................200.................300.....................200...............200.........................100.............200.......................300............300


Now I need to show % variances for each quarter. So the report should look like (similar for Qtr3 and Qtr4):


Supp Name.........................Qtr1 ....................................................Qtr2...................................................Qtr3...........................................Qtr4
.................SuppSales....MemberSales...Variance......... SuppSales.....MemberSales...Variance......... SuppSales...MemberSales............SuppSales...MemberSales
aa.................100.................200...............10%................100...............300..............20%.................300.............300.......................400............200
bb.................200.................300...............10%................200................200..............0%..................100.............200.......................300............300

Now if I set display total to true, it shows me total of Supplier and member for each quarter. But I need to show % variance.
If you want I can mail you the .mrt file which will make things clear.
Please help.

Thanks.

-Ash

[Edward]

Hello, Ash.

Please send that mrt file and if possible data for it in any suitable format to support[at]stimulsoft.com.

Thank you.