topic Re: Two Pivot Table Queries. in App Development

Two Pivot Table Queries.

SteveFewster — Sat, 16 Nov 2024 20:05:52 GMT

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

Re: Two Pivot Table Queries.

brunobertels — Wed, 11 Sep 2019 15:46:10 GMT

highlight max value On the Sales Net Line :

if(aggr(rank(

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

On the Order Units row :still investigate 🙂

Bruno

Re: Two Pivot Table Queries.

brunobertels — Wed, 11 Sep 2019 16:23:59 GMT

And for second color mesure this

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