I have been asked to sort a pivot table in such a manner that It should show those columns first for which the values exists in all the sub coloums.
example we have a table which is having 3 fields like Business name, business sale, profit. now the pivot table should show those fields first in which there is a value in all the 3 fields in decreasing oreder!