
Re: Hihglight min and max in all rows of Pivot
Sunny Talwar Sep 16, 2016 9:40 AM (in response to Dermot mcgoldrick)Lets say your expression is Sum(Sales), then you can try this for color expression:
If(Sum(Sales) = Sum(TOTAL <Dimension1> Sales), LightGreen())

Re: Hihglight min and max in all rows of Pivot
Digvijay Singh Sep 16, 2016 9:45 AM (in response to Sunny Talwar )I think the second Sum should be 'Max' 
If(Sum(Sales) = Max(TOTAL <Dimension1> Sales), LightGreen())

Re: Hihglight min and max in all rows of Pivot
Sunny Talwar Sep 16, 2016 9:47 AM (in response to Digvijay Singh)Yes, you are right , but we might need this
If(Sum(Sales) = Max(TOTAL <Dimension1> Aggr(Sum(Sales), Dimension1, Mth)), LightGreen())

Re: Hihglight min and max in all rows of Pivot
Digvijay Singh Sep 16, 2016 10:00 AM (in response to Sunny Talwar )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?

Re: Hihglight min and max in all rows of Pivot
Sunny Talwar Sep 16, 2016 10:55 AM (in response to Digvijay Singh)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)

Re: Hihglight min and max in all rows of Pivot
Digvijay Singh Sep 16, 2016 10:09 AM (in response to Sunny Talwar )Yeah! We cannot disregard first dim. Thanks






Re: Hihglight min and max in all rows of Pivot
Sunny Talwar Sep 16, 2016 10:05 AM (in response to Dermot mcgoldrick)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())

Re: Hihglight min and max in all rows of Pivot
Antonio Mancini Sep 16, 2016 11:02 AM (in response to Dermot mcgoldrick)
Re: Hihglight min and max in all rows of Pivot
Antonio Mancini Sep 16, 2016 12:16 PM (in response to Antonio Mancini)
Re: Hihglight min and max in all rows of Pivot
Dermot mcgoldrick Sep 17, 2016 12:46 PM (in response to Antonio Mancini)Brilliant guys thanks for this, will get a look at it next week, travelling with work for a few days so might not be until later in week. A useful chart I think though for looking at say order intake and sales across categories!



Re: Hihglight min and max in all rows of Pivot
Gabriel Oluwaseye Sep 16, 2016 12:00 PM (in response to Dermot mcgoldrick)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