background-color dependent on several conditions

[reinholdgraf]

Need to set the background color of an article number in a pivot-table dependent on the following conditions

- number of customers (distinct) >= X

- quantity >= Y

- sales€ >= Z

For a KPI-figure, i used the following:

count({<Menge = {">=1000"}, KundeNr = {">=25"}>} KundeNr)

But for the background, I have no idea, how to set up a formula with multiple conditions

Reinhold

[vikasmahajan]

Changing the background color based on value?

HTH

Vikas

[reinholdgraf]

value vor quantity and sales€

count for number of customers

[marcus_sommer · Accepted solution]

You need to combine these conditions porbably per AND like:

if(

     count({<Menge = {">=1000"}, KundeNr = {">=25"}>} KundeNr) > x

          AND

     sum(sales) > y

          AND

     sum(quantity) > z,

green(), red())

- Marcus

[reinholdgraf]

yes, AND is what I need.

Thank you !