Announcements
cancel
Showing results for
Did you mean:
Creator

## background-color dependent on several conditions

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

1 Solution

Accepted Solutions

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

4 Replies
MVP

Changing the background color based on value?

HTH

Vikas

If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Creator
Author

value vor quantity and sales€

count for number of customers

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

Creator
Author

yes, AND is what I need.

Thank you !