Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am getting an error adding calculated dimension to my pivot table. The expression is =count(student_number)
It is not a problem do display this expression in a text object =count(student_number) = 667
My intention is to see the sum on 453+200+14
Thanks for your help,
Larisa
I think you don't need to create a calculated dimension here, but enable partial sums for your current dimensions on presentation tab. This will get you the totals.
The reason why the calculated dimension does not work: You need to use advanced aggregation aggr() if you want to use aggregation functions in the calc. dimension. But as I said, I believe that's not the way to got here.
Stefan
You can Select the Dimension in Presentation tab and Check Show Partial Sums. You get the total.
To achieve your result. No need to create calculated dimension.
just click Show Partial Sums in Presentation Tab.
Cheers,
thanks a bunch
thank you!
Thank you!