top n analysis with 4 dimensions?

[gauthamchilled]

hi

anyone have idea on how to do top n analysis with more than 4 dimensions and more than 1 expression?

can anyone give me example?

Gautham

[varshavig12]

Rank function can help you

[gauthamchilled]

can you give me an example with 4 dimensions?

[Anonymous]

Hi Gautham,

Do your rank, with rank function, using the last level dimension.

Regards!

[Digvijay_Singh]

See if this can help, I cannot open qvw(using PE) so not sure what is there inside -

Re: Ranking with multiple Dimensions

[susovan]

Hi Gautham,

Is it your requirement?

[sujeetsingh]

There are number of ways well you can use combo charts or straight tables.

[varshavig12]

It depends on your requirement.

You can either do top analysis on the basis of a particular dimension.

Else for multiple dimension

You can check the link which digvijay‌ has given.

[varshavig12]

Can you post a sample of your data and the expected output ?

[gauthamchilled]

Thanks for all...in the attached example...it shows the rank..instead of showing rank..i want to show their values..

eg top 3 values instead of the ranking..

rank(sum(Invoice)) shows only ranks...not the values ..i want values

how can i do that?