topic Background color pivot table based on column total in App Development

Background color pivot table based on column total

vivekraghu25 — Wed, 05 Jun 2024 12:42:14 GMT

Hi all

I've been struggling with this and hoping I could get some help. I have a pivot table with a field called Spec in the Row. The column area has 2 fields, region and area. I have turned on the Show totals toggle for the region column and would like to have all background color based on that totals.

As seen in the attached, I have turned on the "Show totals" toggle on the region column and can see that it is 1.46 for the first item in the row. I'd like the background color of the values in that row to be red if greater than 1.46 and green if lesser. And likewise, apply this for all rows.

Appreciate any help with this.

Re: Background color pivot table based on column total

Antoine04 — Fri, 07 Jun 2024 14:41:47 GMT

Hello,

Is that what you want to do ?

If yes, here is the formula you need to write :

If(ColumnNo()=0,Blue(),
If(Avg(Marge)>Avg(Total <Mois> Marge),Green(),LightRed()))

Regards,

Antoine

Re: Background color pivot table based on column total

vivekraghu25 — Sun, 09 Jun 2024 23:00:54 GMT

Almost. But not exactly. To give an example, If the values in the first row are less than 9,14 then green, else red. Similarly for all rows.

Re: Background color pivot table based on column total

Antoine04 — Mon, 10 Jun 2024 07:12:39 GMT

So, like this ?

Or all the cells compared to 9.14 ?

Regards

Antoine