Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot table total caluculation

Here in the above pivot table .... i want the  Total and the expression for it is ...

11 Replies
linusblomberg
Creator II
Creator II

This forum still seem to have issues after the maintenance and I can't go to your profile. But it doesn't matter. Can you make the correct expression in a textbox?

All I'm saying is that I don't think you can use the approach you're using. You can't reference a column when you want %-totals. Either I would try to use dimensionality() with the expression of the column and include the total (sum(total expression)) but I'm not sure this will work. You can also aggregate the values in the loadscript.

good luck

Anonymous
Not applicable
Author

hi Linus,

give me u r mail id i can send u  expressions.