Skip to Content
Oct 03, 2017 at 12:26 PM

How to get Max value with combination of dimensions in Webi


Hi Guys,

I am stuck with deriving percentage using Max function in my report development.

I need to calculate the Max(%) comparing PO and Item. When i am using the function

=Max(%) ForEach([Item]) In ([PO]) its not giving right value as expected. Can anyone please help me with correct formula.

The data table is as below and Yellow column is expected one.

PO Item % Max(%)