Crosstab - subtotal

[sun2008]

Hi,

In my crosstab I have 3 group subtotals - Total Earnings, Total Deductions, Total Misc
And the Grand Total row (Total Earnings + Total Deductions + Total Misc)

Grand Total Should be :

Grand Total = Total Earnings - Total Deductions. (ignore Total Misc)


Row Description Dept 1 Dept 2
=== =====================
1 p1 100.00 50.00
2 p2 50.00 0.00
TOTAL EARNINGS 150.00 50.00

3 D1 50.00 50.00
TOTAL DEDUCTIONS 50.00 50.00

4. M1 90.00 5.00
TOTAL MISC 90.00 5.00

Grand TOTAL 100.00 0.00 <=


How to make this work ?

Thanks

Code: Select all

Code: Select all

[HighAley]

Hello.

In my crosstab I have 3 group subtotals - Total Earnings, Total Deductions, Total Misc
And the Grand Total row (Total Earnings + Total Deductions + Total Misc)

Grand Total Should be :

Grand Total = Total Earnings - Total Deductions. (ignore Total Misc)


Row Description Dept 1 Dept 2
=== =====================
1 p1 100.00 50.00
2 p2 50.00 0.00
TOTAL EARNINGS 150.00 50.00

3 D1 50.00 50.00
TOTAL DEDUCTIONS 50.00 50.00

4. M1 90.00 5.00
TOTAL MISC 90.00 5.00

Grand TOTAL 100.00 0.00 <=


How to make this work ?

Please, try to use variables. If you couldn't do it. Please, send us your report template with data.

Thank you.

[sun2008]

Hi Aleksey,

Please refer attached file.

Thanks.

[Alex K.]

Hello,

Please check the modified project in attachment.

Thank you.

[sun2008]

Hi,

Thanks. It's working now.

How do I do this :

[1] Change row total caption from "Total" to "Total Income", "Total Dedcuctions"?
[2] Hide the total row for "MISC" - I do not need the sub total for "MISC" group


Thanks.