Straight table

[#1]

Hi everybody,

i have created a straight table showing the revenue for all products. Because of the table size i just want to show the top 10 products. My problem is, that the total i can choose in the properties shows the total of all products, but i just want to sum up the top 10.

Does anyone know the answer.

Appreciate any help in this regard.

Thanks and Regards

Philipp

[#2]

Always i have a same problem...

I do a trick.....lololol......a calculated a total of top 10 on the text object and fixed it on the total of straight table.....

if anyone have another solution..... i appreciate too

[#3]

Could you explain your problem again?

Sorry I didn't get it.

ERP Consulting

SAP ERP Consultants

[#4]

Hi, the following is an example for my problem. First example are the complete products with their revenue.

Product	Revenue
A	50
B	40
C	30
D	20
E	10
Total	150

Now i just want to show the top 3 ans the sum just for this 3 products (green). The only thing i reached so far is the red, which is the total of all products again.

Top 3
A	50
B	40
C	30
Total (for Top 3)	120
Total	150

Thanks

Philipp

[johnw]

dimension = Product
expression = if(rank(sum(Revenue))<=3,sum(Revenue))
total mode = sum of rows
max number = 3

[sunil2288]

HI Philip

You can use the Pareto select option by creating a button.

What you supposed to do is ..

Create a button named TOP 30 then in the properties of button add action as select--> Pareto select

here set Field as Product and expression as sum(revenue) then set the percentage you want to view let it be 30...

Hope it will solve your problem...

[#7]

This is simple..

First check the "Restrict values to" option in the Dimensional Limit tab from the Properties of the straight table.

now select largest 10 values and uncheck show Others.

Now in the expressions tab, in the right hand side part, in total mode select sum of rows.

I hope this will solve your problem