Pivot table error

[#1]

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

[swuehl]

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

[amayuresh]

You can Select the Dimension in Presentation tab and Check Show Partial Sums. You get the total.

[tyagishaila]

To achieve your result. No need to create calculated dimension.

just click Show Partial Sums in Presentation Tab.

Cheers,

[#5]

thanks a bunch

[#6]

thank you!

[#7]

Thank you!