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_1-1658431373092.png](https://community.qlik.com/t5/image/serverpage/image-id/84806i96911AAAEBFE9C67/image-size/medium?v=v2&px=400)
![aknabe1_2-1658431471317.png aknabe1_2-1658431471317.png](https://community.qlik.com/t5/image/serverpage/image-id/84807i3EFD97BBDB92FDA4/image-size/medium?v=v2&px=400)