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 Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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: 
brijesh1991
Partner - Specialist
Partner - Specialist
‎2021-02-10 07:01 AM

Pivot Table: Calculated Dimension Total

Dear All,

Looking for a Total for calculated dimension in Pivot table.

Basically I have 3 measures (Vol,%XYZ,%ABC) and 2 dimensions (Category,MonthYear).

I want to split %XYZ and %ABC by MonthYear (Second dimension); However first measure (Vol) should not get splited by MonthYear, so my instinct asked me to place it under Calculated dimension. However Total for the calculated dimension not visible and even wrapping aggr expression with Sum shows invalid row error.

Please suggest how can I achieve this either with the same manner or any other technique please.

prob statement.png

Preview file
28 KB
522 Views
0 Likes
0 Replies