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.
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.
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()))
Thanks you so much, that works!
Regards,
Romina.
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