Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've a table like show below:
Column1 | Column2 | Column3 | value |
A | 1 | 10 | |
A | 2 | 1 | 10 |
A | 3 | 10 | |
A | 4 | 10 | |
B | 1 | 12 | |
B | 2 | 12 | |
B | 3 | 12 | |
B | 4 | 1 | 12 |
C | 1 | 13 | |
C | 2 | 13 | |
C | 3 | 1 | 13 |
C | 4 | 13 |
- I want to display in pivot table with col1 & Col2 as dimension and in expression as background color as red when col3 is 1 and Max of Value column. But this chart should be static, no filters should effect this chart.
As shown below please help me:
Hi
Try like this,
if(rank(Max({1}Value),Col1) and Col3 = 1, Red(),Green()) use in text color in expression tab "+" sign
and use Max({1}Value) as expression or use {1} in ur expression..
Hope it helps
or try
if(value = Max({1<Column3={1}>}total value) and Column3=1 , lightred(), lightgreen())
as background expression
Hi,
Thanks a lot. But i'm not able to change the concept into my application. Please see this application.
In my application where ColorFlag is 1 and Max(Date) i want to display in 3 expressions as Dia,power,Temp as red color, if it not satisify the condition it should show green color with same names. I need background colour not text colour.expression header should be in plain not should be in colour.
Hi,
As shown in below image for selection. Here i've selected AnoPLDate as 6(i.e i've generated autonumber for each date, instead of date i'm taking autonumber later i'll take date column). For our reference i've selected 6(i.e Feb 06).
- as shown in above image selections what i did. i need in pivot table as below image.
Can anyone help on this. I'm getting mad here to achive this. It is very urgent for me.
Hi
Use like this,
For 1st-> if(rank(Only({<v1={'Dia'}>}v1)) and ColurFlag = 1, Red(),Green())
For 2nd -> if(rank(Only({<v1={'Power'}>}v1)) and ColurFlag = 1, Red(),Green())
For 3rd-> if(rank(Only({<v1={'Temp'}>}v1)) and ColurFlag = 1, Red(),Green())
Hope it helps
No use. Please try in my application.
Hi
check this,