Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table calculated Dimension not applying filter of other dimensions

I have a Pivot Table.

yearfirstsales.PNG.png

The column 'Year of first Revenue' is a Calculated Dimension with this formula

=IF($(=Sum({<[Fiscal Year]={$(=(vCurrentYear)-2)}>}[Sales Amount])) = 0, 'None', $(=(vCurrentYear)-2))

The result in column Year of First Revenue is not applied the filters of other dimensions, namely Product Group des, Product Sub Group Desc etc... In other words, (=Sum({<[Fiscal Year]={$(=(vCurrentYear)-2)}>}[Sales Amount]))  is the sum of all sales for 2009 for all Product Group Desc, Product Sub Group Desc etc...

I would like the value for the dimension Year of first Revenue to be the sum of Sales Amount for each individual cell in the Pivot Table.

Is there a way to implement this ?

Regards

0 Replies