Skip to Content
avatar image
Former Member

Sum of Top n Revenues

Hi

Could any body help in find out the Sum of top 3 Revenues Using Variable in Webi Report.

Below is the data

Region Co. Name Market Unit Revenue

APJ XYZ

APJ XYZ

APJ XYZ

APJ XYZ

APJ XYZ

APJ XYZ

APJ XYZ

APJ XYZ

APJ XYZ

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 04, 2017 at 12:40 PM

    have you tried with Rank() function in webi?

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 04, 2017 at 01:40 PM

    try similar to this.

    First create dimension variable for your measure object.

    V Total=[Unit Revenue]

    =Sum([V Total]) Where (Rank([V Total;Top)<3 )

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Amit,

      Thanks for the reply,

      The above formula is not working. Let me explain you in detail. I need the sum of top 5 revenue total to be displayed in multiple cells under different tabs in the report.I could have chosen sections if it was to be done in one report.I need this in Variable.

      I tried using the Rank but could not get the output.

      Please guide

      Thank you in advance.

  • avatar image
    Former Member
    Dec 04, 2017 at 12:58 PM

    Yes i Tried Rank but getting total of all the records

    Add comment
    10|10000 characters needed characters exceeded