Highlight max and min values in pivot table

[pljsoftware]

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.

[Anonymous]

Thanks both of you, but... There is another solution for this question?

In the file that Sebastián posts, you can see that expression doesn't mark the max. I don't know why, 'cause looks fine and logic, but it doesn't. Also for the min function, marks the same values that the max function.

Regards.

[sebastiandperei]

Sorry, I made a mistake with no test the solution provided.

This works properly:

If(Sum(Data)=max(Total <Field2>Data),

          yellow(),

          If(Sum(Data)=min(Total <Field2>Data),

                    Green()))

[Anonymous]

Thanks you so much, that works!

Regards,

Romina.

[Anson]

Hi, 

Thanks a lot to provide the solution. Your solution is to identify the Max value in total cells. 

And I meet a difficulty to identify the Max value per row in the pivot table. 

Do you know how to write the expression? 

Regards,

Anson