Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi friends,
is it possible to set behavior of value in column "A" on pivot table to following rules?:
- pivot table (chart object)
- dimensions: year, month, business case (string), deliverable (string)
- expressions: weighted total (in €), total (in €), invoicing probability (in %)
if value "invoicing probability" in row is less than 100 (%), I would want to set color (font) for value "weighted total" to RED. Else value will have GREEN font.
very thanks for tips
Hi Juraj,
You can try this.
Go to Expression Tab and expand the expression "invoicing probability" and write the expression in Text Color like
= IF( Sum(InvAmount) > 100, Red(), Green() )
Regards,
Raj Kishor
Hi Kishor,
it doesn't work. I need following behaviour:
I think that I must to this in tab "Visual Cues" or no?
I try followings (set on expression "ColumnA"), but no does work also:
IF([ColumnB]*[TotalAmount]<[TotalAmount],Red(),Green())
IF([ColumnB]<100,Red(),Green())
IF([ColumnB]<'100%',Red(),Green())
some other tip please
Hello!
insted of 100 use 0.1
may be tht works ......
Hi Kishor,
very thanks. It's my mistake.
It does work! Super!