Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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...
put an condition
=match(Field,'first','second','third')
Suppose if i have million IDs, should i write all IDs?