TOTAL for the columns of crossTab ?

[NicolaTesla1]

Hello,

1- I have this crossTab with lines and columns and 1 implicit measure on the corner of the crossTab.
2- I need to have TOTALS of all the columns of my crossTab
3- I tried by adding a crossTab space on the last line of my crossTab and it kind of works but not completely. Only the columns associated with
the implicit measure (the measure on the corner of my crossTab) seems to have a TOTAL.
4- But i need TOTAL for all other columns (some of them are also different measures)

anyone has any suggestions ?

Thanks !

 

[masterj1109]

you should be able to use the agg function in the toolbar just as you do in a list, you may have to play around with it a little bit to select the right column/row you are wishing to see the total on, but if you can give me a better break down of your crosstab I can probably give you a more detailed description of how to create your totals.