Wanted to add one more total column in the cross tab

hi,

I'm created cross tab in that i'm having 2 summary field on that basis i got 2 total columns(aggregation) .
These total field i got by doing the clicking on group field and their I'll get one option called total after clicking that one more column added in the cross tab now whatever 2 columns i got , for these two column i wanted to add one more column that is grand total.
bellow i have attached and clearly mentioned in the snapshot as well as rpt design also attached.

plz help me out for the same

Thanks & Regards
Santosh

Find more posts tagged with

Comments

mwilliams

Hi santoshlb,

If you add a grid to the grand total area with multiple columns and one row, you can drop the current "grand total value" into one cell and add your own label and data element or aggregation to the other cell and then just set the cell widths to make them all equal. Let me know if you need further explanation!