Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm currently trying to colour a dimension on a pivot table as below.
Source | Month | Value |
---|---|---|
A | Oct | 0 |
Nov | 2 | |
Dec | 2 |
I want to have the source turn red when the value per source exceeds 3, however because the value is split by month the colour is not applying.
Thanks in advance.
CJ
I was looking for the sum of source, not the individual months... with some looking up of the aggr function I have what I need
this gives me the amount per source
aggr(sum(Value),Source)
and the accompanying if statement
If(
aggr(sum(Value),Source)
>3,
rgb(200,10,10)
)
try this in background color of Source.
aggr(if(Value>3,red())Value)
Hi.
If you mean "value in any month of source exceeds 3", try this as a background color expression for Source dimension:
=if(Min(aggr(Value>3, Source, Month)), red(), null())
I assumed that you have two dimensions Source and Month.
I was looking for the sum of source, not the individual months... with some looking up of the aggr function I have what I need
this gives me the amount per source
aggr(sum(Value),Source)
and the accompanying if statement
If(
aggr(sum(Value),Source)
>3,
rgb(200,10,10)
)
In this case the "total" statement is useful to discard some dimensions:
If(sum(total<Source> Value) >3, rgb(200,10,10))
This will also work for Month dimension.
Hi:
I want to color code my dimension field (and dimension only) based on the value of the dimension (not the value of the expression).
Is this possible?
Also, where can I find the background color expression for dimension? I can only find the background color expression for expressions.
Thank you very much.
Paco