Skip to Content

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(%)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 04, 2017 at 03:37 PM

    try this.

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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 03, 2017 at 12:30 PM

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

    Add comment
    10|10000 characters needed characters exceeded