Max 10 or Min 10 Value in PivotTable.

[sona_sa]

Hi,

Do we have maximum no. of sale in pivot table. We can do it in all chart including straight table also, but in pivot table there is no option.

Regards,

A Kumar

[Anonymous]

Hi,

Try this in Exp

=Sum({<Region={"=Rank(Sum(Sales))<6"}>} Sales)

Regards,

Snehal

[sona_sa]

Hi Snehal,

Thanks for replpy, But can you check it for multiple dimesion.

Regards,

A Kumar

[jagan]

Hi,

Try using Total in the Rank()

=Sum({<Region={"=Rank(TOTAL Sum(Sales))<6"}>} Sales)

Regards,

Jagan.