Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
I have a Pivot Table with many dimensions and one expression. Is it possible to highlight the cells that contain max and min expression values, depending on the current aggregations?
Kindest Regards.
Hi all,
we have a pivot table with these dimensions
Week (Settimana)
Data (Date)
Ora (Hour)
Expresssion: QtaPasseggeri (quantity of passengers)
with espression sum(QtaPasseggeri) and expression name "Passeggeri".
The solution for this problem is to set this expression in Background Color
if([Passeggeri]=max(total aggr(sum(QtaPasseggeri), Settimana, Data, Ore),1), rgb(255,0,0),
if([Passeggeri]=max(total aggr(sum(QtaPasseggeri), Settimana, Data, Ore),2), rgb(200,0,0),
if([Passeggeri]=max(total aggr(sum(QtaPasseggeri), Settimana, Data, Ore),3), red(),
IF([Passeggeri]>800,
RGB(0,0,128),
IF([Passeggeri]>400 AND [Passeggeri]<800,
RGB(0,204,255),
IF([Passeggeri]>200 AND [Passeggeri]<400, RGB(204, 255, 255))
)
)
)
)
)
Regards
Luca Jonathan Panetta
Hi,
Write some thing like this in background properties of the expressions by click on plus sign.
If( Sum(Sales) = Max(Sales) ,Yellow(),
If( Sum(Sales) = Min(Sales) ,Green() ))
Rgds
Anand
No, it doesn't works. Your example draws all the cells with a yellow background.
Hi,
Can you share any sample file it goes so easy.
Rgds
Anand
1.go to chart properties of pivot table and go to tab visual cues.
2.select expression and give upper limit and lower limit.
3.Then the values between upper and lower limit will be highlighted.
try it out.
regards
You can do one more thing..
Go in the visual cues tab....Here yo u will find the Upper and Lower Value....you can fix the color according to your reqirement
I have the same question. But I ordered the values ascendant by this expression:
min(aggr(count(Field), Dimension 1, Dimension 2))
But doesn't order. I want min values on the top of the table so I can highlight them and the max values down.
Please attach the application. We all can help you out with that!
Hi,
Write some thing like this in background properties of the expressions by click on plus sign.
If( Sum(Sales) = Max(Sales) OR Sum(Sales) = Min(Sales) ,Yellow())
Hope this helps!
Thanks,
Attitude
If( Sum(Sales) = Max(Sales) OR Sum(Sales) = Min(Sales) ,Yellow()) doesn't work.
This is the example. I want max and min values by Field2.