Hihglight min and max in all rows of Pivot

[dmac1971]

Any way to do this, example of max's highlighted below

[sunny_talwar]

Lets say your expression is Sum(Sales), then you can try this for color expression:

If(Sum(Sales) = Sum(TOTAL <Dimension1> Sales), LightGreen())

[Digvijay_Singh]

I think the second Sum should be 'Max' -

If(Sum(Sales) = Max(TOTAL <Dimension1> Sales), LightGreen())

[sunny_talwar]

Yes, you are right , but we might need this

If(Sum(Sales) = Max(TOTAL <Dimension1> Aggr(Sum(Sales), Dimension1, Mth)), LightGreen())

[Digvijay_Singh]

You are right we have to have Aggr function to select max out of all months sum(value), but I think that is sufficient, do we need total<dim> now?

[sunny_talwar]

I think we still do because for a chart with Dimension1 and Mth as dimension

the each cell value using this expression

Max(Aggr(Sum(Sales), Dimension1, Mth))

will equal

Sum(Sales)

[sunny_talwar]

I just noticed there is a third dimension and the expression might need to be changed a little more

If(Sum(Sales) = Max(TOTAL <Dimension1, Dimension2> Aggr(Sum(Sales), Dimension1, Dimension2, Mth)), LightGreen())

[Digvijay_Singh]

Yeah! We cannot disregard first dim. Thanks

[antoniotiman]

Try

If(RangeMax(First(Sum(Value),1,NoOfColumns()))=Sum(Value),Green(100))

[Gabriel]

Hi,

Try this expression

IF(SUM(Value)=RANGEMAX(TOP(TOTAL SUM(Value),1,NOOFROWS(TOTAL))),GREEN()

,IF(SUM(Value) = RANGEMIN(TOP(TOTAL SUM(Value),1,NOOFROWS(TOTAL))),RED()))

Hope it helps