topic Re: Background Color in Pivot Table based on different conditions for Auto Totals ad Field Values in App Development

Background Color in Pivot Table based on different conditions for Auto Totals ad Field Values

heiko_schmidt — Sat, 16 Nov 2024 19:04:56 GMT

Hello, I use Background Coloration with conditions in Pivot Table to Highlight some Values.

Let´s say I want a green Background Color if the Value is greater than 20.

Now if I use the autogenerated Totals in Pivottable i get the Coloration in Totals Rows and columns for the same condition, but for example i want the Totals only to have a green Color if the Total Value is greater than 50.

Is that possible?

Best Regards

Heiko

Re: Background Color in Pivot Table based on different conditions for Auto Totals ad Field Values

Anil_Babu_Samineni — Thu, 20 Feb 2020 09:55:10 GMT

Please provide more info about how it should be, May be supply sample dashboard and explain the scenario.

Re: Background Color in Pivot Table based on different conditions for Auto Totals ad Field Values

heiko_schmidt — Thu, 20 Feb 2020 13:17:10 GMT

Shure, here is an example.

As you can see the Totals row and column also have a background color and use the same condition as all other cells in this pivot table.

Now i want to use another condition for coloration of these totals.

Best regards

Re: Background Color in Pivot Table based on different conditions for Auto Totals ad Field Values

mfarsln — Thu, 20 Feb 2020 14:49:21 GMT

Hi,

You can use Dimensionality() function to give specific colors for totals.

Below code makes your totals green if totals > 50 and makes your other cells green if value of those cells > 20

if(Dimensionality()=1, if(Value>50, green(), red()), if(Value>20, green(), red()) )

Re: Background Color in Pivot Table based on different conditions for Auto Totals ad Field Values

Anil_Babu_Samineni — Fri, 21 Feb 2020 09:37:40 GMT

Yes, That's possible. But you need to do some custom setup with Inline load. Please try to attach sample file which demonstrates the issue.