How to sort data in pivot table using tools other than slicer

[murali476]

Dear all,


I have been facing this problem recently. Using slicers I am not able to sort the data as I wish. It is giving the intersection of the data but not the union.


For Example:


I have a data like

name desig points 2011 points 2012

ws we 21 0

s ds 21 23

ds fg 0 34

d fgcd 23 25

sd rgdf 12 0

fd ret 12 14

sda fd 34 36

asd sa 45 47

da ss 4 6

rt rer 62 0

gdf gr 32 34

fg gry 4 6

dfg yr 0 34

dgreg hyhy 0 0


Now I don't want to see those who has both zeros only.

If I use slicer I am making all the rows who has even single zero is also getting hide.


Please suggest me a solution.

 

[keymaster]

@Murali...


Instead of using slicers on values, here is what I suggest:


create an extra column in your original data and fill it with YES if any one value is not zero and NO other wise. Then add a slicer for this new column in your pivot. This should fix the problem.

 

[murali476]

Hi,


Thanks for the reply. . .

It is ok for this case.

Suppose if I have 3 calculated fields in the Pivot Table I can't do all the calculation in the original sheet.


So please suggest me an alternative solution.