Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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

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

Community Browser