Calculating TOP 10 VALUES in PIVOT TABLE

[#1]

Hi people,

I have a Pivot table as

Division               Area                     Zone              Cost

London+              East+                 stratford           200

                                                    eastham          8000

                                                    Westham         510

                                                      .

                                                      .

                                                      .

                          West+                Epping               2000

                                                    Heathrow           788778

                                                    Harrow               4578433

                                                    .

                                                    .

                                                    .

                          North+                Harrow               366987

                                                    Watford              451

                                                    .

                                                    . 

I need to calculate the top 10 values by cost in a pivot table. Can anyone help with this please.

Regards,

KV.

[Anonymous]

Rohit,

what is your current expression?

Thanks

Bon.

[#3]

Hi ,

Rank( Aggr((Sum(Ape)), Col,Channel,Appno),0,1)  this is my current expression

[pgriffiths]

Thanks,
This was causing me a big issue. Great workaround.

[pillasi_007]

Hi All,

I have used similar expression for getting the top 10 results in pivot.

But still cannot get the desired result. Can anyone help me fix this?

[pillasi_007]