Two Pivot Table Queries.

[SteveFewster]

Hello, 

I'm trying to do two things on a pivot table attached but having no luck thus far with colormix, aggr, after, previous etc. I'm not sure if it is because I have no dimensions of the rows, just measures. 

On the Sales Net Line I'm trying to highlight the background of the highest value on the row. 

On the Order Units row, I'm trying to compare the most recent period, 1st column 1906, with the previous and indicate if it is up or down and also apply this on each column. 

Thanks

Steve

[brunobertels]

Hi 

highlight max value On the Sales Net Line :

if(aggr(rank(

Sum(sales),Dim1)=1,LightBlue())

On the Order Units row :still investigate 🙂

Bruno

[brunobertels]

Hi 

And for second color mesure this 

if(
Sum(sales)
<
before(
Sum(sales)),lightred(),lightgreen())