Tried to use search, but didn't find anything.
Here is a problem:
I try to add a calculation field to my pivot table that suppose to calculate:
value for specific field divided by maximum value of another field.
I try to make something like:
= Value1 / MAX(Value2)
The problem is: MAX(Value2) is calculated for specific field but not for the whole table as I need it. Is there any way to solve that?
Thanks in advance.
Bookmarks