Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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