Finding Top n values

[#1]

Hi,

I need to show the Top n values based on the selection in the slider.

I have two dimension(Year and Product ) in Pivot table. I have to show the top n Product's Sales for each year.

I managed to get the top n values. But when I select a value in the slider, Total values(Partial Sum) are not showing the correct value.

[Miguel_Angel_Baeyens]

Hello,

Take a look at this thread and the attached application. The issues may appear when there are several excluding dimensions (on product may be the most sold in one year but not in the other...)

Hope that helps.

[#3]

Had a similar issue once. Basically I just turned your expression into a dimension so only Prod_Names that fulfill the Top Slider requirement are returned. Then for the expression, you simply use sum(Sales).

Attached is my attempt.

[#4]

Forgot you had a cyclical group. Attached is another attempt. Just adds two expressions to the cyclical group called Group2. Will make more sense when you see it.

[llauses243]

Hi shans_bala,

Pls to correct error value on data .xls and try again (see image attached)

Good luck, Luis.