i have some item ids and spend, i want to sort top 3 items based on sum spend, How can we do that in pivot table

[#1]

i have some item ids and spend, i want to sort top 3 items based on sum spend, How can we do that in pivot table

[shraddha_g]

In Dimension - there is a Property called Limitation with default value as No limitation. Change it to Fixed Number - Select top and enter 3 in Text Box

[#3]

i am able sort top 3 items but they are sorting in unusual manner. 1st spend coming in 2nd place 3rd item in 1st place, i want those item on the basis of spend , i mean 1 st item should be top spend item....Thanks in advance...

[Chanty4u]

put an condition

=match(Field,'first','second','third')

[#5]

Suppose if i have million IDs, should i write all IDs?