Selecting top 3 values

[rohitians]

Hello,

I have this pivot chart where in I have a cyclical drill which has compny , therapies  as dimensions which has many brands with sales values,

Now there are many brands i only want to show number of brands the user wants or selects in the input box....

Is this possible...

Thanks and Regards,

Rohit

[#2]

take straight table--presentation tab--> check the dropdown select after select field

[anandathome]

1. Add a list box for brands on the sheet.

2. Select the brands you don't want to show.

3. Right click on the list box and "Select Excluded"

4. Lock the selections.

[rohitians]

Hello,

I have this pivot table where in i have Companies with their brand names ,I am diplaying sales of this brands CYvsLY..

Now the scene is i want to show only a particular number of brands i.e input box the user may select i want to see only top 3 brands of all companies

so as per the number only 3 top selling brands should be displayed for each company and total sales for that company should be dispayed...

I am attaching a sample qvw file in order to get an idea of the report...

and is it possible to achieve the same...

Thanks and Regards,

Rohit

[tresesco]

PFA. Hope this helps.

Thanks.