How to get Max value with combination of dimensions in Webi

[former_member392781]

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(%)

[amitrathi239 · Accepted solution]

try this.

=Max(%) in ([Item];[PO])

[former_member392781]

Sorry for my question without table. Table is as below. And yellow column is expected column.