Top xxx based on Slider

[tmumaw]

I have created a slider with values 1 - 500. Then I have a customer list by customer/address, sales $. My user wants to be able to see the number he selected from the slider as a count be side each customer. Something like this. The row count has to be based on the slider. Thanks

1 customer 1 address sales $

2 customer2 address sales $

[tmumaw]

Will this work with multiple dimensions? I have 5 dims (Customer Name, Address, City, State and Zip). Here is my dim logic

=If(aggr(rank(aggr(sum([Inv Gross]), [Customer - Code & Name]), 4, 2), [Customer - Code & Name]) <= $(vHowMany), [Customer - Code & Name], 'Others')

expression :

Rank(aggr(sum([Inv Gross]), [Customer - Code & Name]), 4, 2)

Thanks Thom

[tmumaw]

Miguel,

It works fine on just one dimension.

Thanks
Thom

[mazacini]

Hi Miguel

I am a Personal Edition user, so opening your demo is a problem - see error message below.

Is there any way around this?

Joe

[Miguel_Angel_Baeyens]

Hello Joe,

I'm afraid there's not. I don't have any personal edition available to make readable the file.

Anyway, it has the same code used in my previous posts here.

Regards.

[#6]

Hi Guys, this has helped me a lot thanks. I have built a slider to show sales for the top "vHowMany" customers, showing the data in a pivot table.

What I want to do now is add a new object (pie chart) at the bottom so that if you select the top "vHowMany" customers, it shows which products they have bought (i.e Dimension="Product", Expression="Sum(SALES)). However, because your example sets all other customers to "Other", the pivot chart shows product split for every customer (including "Other").

Do you know how to build the rank code into an expression, so that only the products bought by the top "vHowMany" customer show?

Thanks,

R