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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
nachofernandez
Partner - Contributor III
Partner - Contributor III
‎2015-06-23 11:22 AM

Subtotals in the same column as dimension in pivot table

Hi all,

I have 1 dimension (Category) with these values:

B1,B2,B3,E1,E2,E3,F

is there a way to achieve a pivot table like this in QlikView?

  

CategoryFranceUK
B11.000,00 €500,00 €
B22.000,00 €1.500,00 €
B33.000,00 €2.000,00 €
Group B6.000,00 €4.000,00 €
E1500,00 €600,00 €
E2500,00 €600,00 €
E3500,00 €600,00 €
Group E1.500,00 €1.800,00 €
F7.500,00 €4.500,00 €
TOTAL15.000,00 €10.300,00 €

Best regards.

267 Views
0 Likes
0 Replies