Creating reports and dashboards | Stimulsoft community forum

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

Hello.

sun2008 wrote: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.

Hi Aleksey,

Please refer attached file.

Thanks.

Hello,

Please check the modified project in attachment.

Thank you.

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.