Top 20

[krishna20]

Hi Friends,

I'm having two dimensions Vehicle Make and Vehicle Model.

I need to show top 20 vehicle make in pivot table along with the model.

For Eg;

Vehicle Make   Vehicle Model

Audi                  S8Saloon

                         S7

                         Q7

                         AR1.8

Ashok Leyland   Ashok Leyland

                        Bus

                         Refrigerator

Like above example based on loss ratio i need to show top 20 vehicle make in pivot table.How can we write rank expression for this.

I tried as like

Aggr(IF(Rank(((Paid+OS)/Premium),19)<=20,Vehicle_Make),Vehicle_Model,Vehicle_Make)

I need to show Vehicle model also in the dimension as above example

Please anyone suggest me.

Regards

Krishna

[ToniKautto]

Do you have a sample QVW that you could attach to make it easier to work out the required expression?

[krishna20]

Hi Toni,

Thank you for reply.

Here with i attached the sample app.

[ToniKautto]

There could be two ways for you to resolve the issue. Either by using Dimension Limit or an expression that returns NULL on the undesired rows. Suppress Zero-Values will hide the NULL values rows.

[krishna20]

Hi Toni,

Sorry, I need to show two dimensions in pivot table. Among that i need to show top 20 based on parent dimension.

Please suggest me based on this requirement.

[vvvvvvizard]

Use input box

CHnage sort order

[krishna20]

Hi ,

Thank you for reply. sorry, It won't reaches my requirement. I'm having another ten expressions need to include in the pivot table.Please find the sample app. In this app i'm showing all the values.Need to filter only top 20.

[krishna20]

Sorry missed to attach.Please find here.

[ToniKautto]

I am not sure I completely understand what 20 values you expect to find. 20 values or 20 rows?

Could you provide an excel sheet that shown the result you expect to find in chart?

[krishna20]

Hi Tony,

Please find the attached excel. I mentioned in the excel sheet clearly . If you need any clarification  further kindly ask .