Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
harleen_singh
Creator III
Creator III

Total and expression in pivot table

Attached is the excel, where i need a "Total" of the hours written with one expression.

Also i need to apply formula where i can divide "Total of Hours/some value" and show it next to the "Total" just like attached excel.

is it possible in pivot table?

thanks

Lavi

3 Replies
vikasmahajan

You need to load data in cross table format

- create pivot table

Then this is possible.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Sokkorn
Master
Master

Hi Lavi,

Can you share your sample app?

Regards,

Sokkorn

Not applicable

Hi Lavi,

Please find the attachment.