- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Tags:
- conditions
- if
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
value vor quantity and sales€
count for number of customers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yes, AND is what I need.
Thank you !