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

how to get total at the bottom of pivot chart for calculated dimension

I have a calculated dimension FTE i need to get Total at the bottom of the pivot chart ? i have used aggregation function could any one of you suggest me how do i get total for calculated dimension?

   

DepartmentFTEHoursClient
Management20109
Creative302550.25
Media2830-
Operations260.292226
Planning40.6412-
Technology91.8213225.5
Total112310.75
1 Reply
sunny_talwar

Instead of bringing it as a calculated dimension, why don't you bring FTE as an expression which you can then easily show a sum for?

Best,

Sunny