rank top 10 based on one dim having other dimension in table

[Anonymous]

HI,

                i want to create a pivot in which top 10 states as per sales (by sum group by state) also want to share products sold in each states such -

any solution  guys

[arvind_patil]

Hi Ankit,

Try Below Expression :

Your Dimension is :

State

Measure:

1.Sum({<State = {"=Rank(Sum(Sales)) <=10"}>}Sales)

2.count( Distinct Products)

Thanks,

Arvind Patil

[Anonymous]

i need to show Products name as well

[vishus913]

Hi Arvind,

Can you please explain how this code works??

[niclaz79]

Hi,

As per above picture you will need to create a calculated dimension such as:

Aggr(Sum(Sales), State)

And then have the Products as a third dimension and the expression to be Count(Products) or Count(Distinct Products) depending on what you intend to show.

[Anonymous]

i need top 10 only

[Anonymous]

i need top 10 only and rank function is not working with second dimension

[arvind_patil]

I will sahre you sample qvf.