Skip to main content

Qlik

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
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
358 Views
0 Likes
0 Replies