How to get Top10 in pivot

[savithri_n_s]

Hi,

I have table like below. I want top 10 based on county,Client Normalized and Sourcing method = 'Targeted Work order

And also how to hide Sourcing method column however i want to see requisitioned an Targeted work order.

[sunny_talwar]

Can you share expected output in an excel file?

[savithri_n_s]

[sunny_talwar]

This

[isingh30]

Can you share your data? excel file..

For top 10 please use top function in the main script. Sourcing method column is normal column or calculated one? We do have option to hide column in straight table but in pivot table there is no such option. You have to use macros.

[savithri_n_s]

Sunny is it possible to display only first top 10 . As we see 12 lines

[savithri_n_s]

This how it should look

[savithri_n_s]

I want top 10 in pivot based on # of non Competitive Rate WO.Can you please help? This in dashboard 11 of qvw file and 2nd table.

Below is the output I am looking for

[qv_testing]

have a look sheet 13

Use as Calculated Dimension:

=AGGR(IF(Rank(Count({<[Comp vs Non-Comp] = {'Not Competitive'}>}[Contractor Name]),4)<=10,[Client - Normalized]),[Client - Normalized])

[savithri_n_s]

Thank you