Skip to main content
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: 
aknabe1
Contributor II
Contributor II

Conditional Formatting in Pivot Table - Reference Totals Column

Working with monthly data in a pivot table, I am trying to apply conditional formatting to the most recent month, comparing to that dimensions totals column.  The logic to only compare and color the most recent column is working, I am just comparing to the incorrect value (not total). 

Is there a way to apply secondarydimensonality logic within the avg(total<Segment Name]>Waste) formula? 

 

aknabe1_1-1658431373092.png

 

aknabe1_2-1658431471317.png

 

 

 

Labels (2)
0 Replies