topic Re: Show different measures in pivot table in App Development

Show different measures in pivot table

sammyak — Tue, 20 Nov 2018 04:30:32 GMT

Hi,
I am wondering if we acheive the below in qliksense. I have a pivot table where i have 1st dimension as country and 2nd dimension as states and in the meausre sum of sales.
The challenge that i have is that sum of sales for country is not same as sum of sales for states. Sum of sales is a calculated field i just want to display this. While using a pivot it calculates sum of all the states which is 720. But the amount to display is 500, which is already calculated. States below when added gives me 720. I want to show top 3 or n states below and have a country total populated as 500. Is this possible ?
Country / states sales
USA 500
California 100
Arizona 20
Aiowa 50

Re: Show different measures in pivot table

Anil_Babu_Samineni — Tue, 20 Nov 2018 04:51:20 GMT

If you can share sample test file and expected result. That would help us to check

Re: Show different measures in pivot table

shiveshsingh — Tue, 20 Nov 2018 05:23:19 GMT

Could you share sample data to work upon along with expected output? Not able to understand your concern.

Re: Show different measures in pivot table

sammyak — Tue, 20 Nov 2018 20:13:10 GMT

Thank you for replying. The dimensionality() functionality serves the purpose. What i was trying to acheive.