Skip to Content
0

Sum of Top n Revenues

Dec 04, 2017 at 12:33 PM

31

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Dec 04, 2017 at 12:40 PM
0

have you tried with Rank() function in webi?

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Dec 04, 2017 at 01:40 PM
0

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 )

Show 1 Share
10 |10000 characters needed characters left 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.

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

Yes i Tried Rank but getting total of all the records

Show 1 Share
10 |10000 characters needed characters left characters exceeded

variable you need to display total of 3 in seprate block or you want to show in the table total?

0