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: 
manoj217
Creator III
Creator III

pivot table converted in cross table

Hi i have a pivot table in the fields have

report name

report path

month

count of report names

these are the dimensions and expressions, count will shows based on each month

in normal view it will shows the total count based on all months for the particular report. when i do cross table it will shows only the count will be in based on month not the total month countCapture.JPG

it is showing only individual month count when i do cross table it is not showing total months count.

But in normal mode it is showing total month count.

6 Replies
andrey_krylov
Specialist
Specialist

Hi Manoj. Can you show the expression?

manoj217
Creator III
Creator III
Author

count(report name)

manoj217
Creator III
Creator III
Author

i done month table as cross table so it will show the count based on month its fine but i want total count as well.

andrey_krylov
Specialist
Specialist

Sorry, it seems I do not understand what you are trying to achieve. Maybe you can share a sample

vishsaggi
Champion III
Champion III

Did you try checking show partial sums for Month field in your presentation tab of pivot table chart?

vinod22kv
Creator
Creator

Hi,

Hope This video will help you.

https://www.youtube.com/watch?v=5eMV5NQY-5g

Regards,

Vinod.