Hi I have a pivot table "F.Up". I don't want items that don't belong to the Opretion Thanks
M Mamdouh Elfors Member Nov 8, 2019 #1 Hi I have a pivot table "F.Up". I don't want items that don't belong to the Opretion Thanks Attachments Agri.xlsm 67.9 KB · Views: 6
p45cal Well-Known Member Nov 8, 2019 #2 Try filtering the Item using Value Filter, and choosing: Sum of Values2 does not equal 0
M Mamdouh Elfors Member Nov 9, 2019 #4 p45cal But when I filter, the opretion name is hidden because it corresponds to 0 in the items Please reconsider again
p45cal But when I filter, the opretion name is hidden because it corresponds to 0 in the items Please reconsider again
V vletm Excel Ninja Nov 9, 2019 #5 Mamdouh Elfors 1) Field Headers ON 2) Do filtering with Item eg below
p45cal Well-Known Member Nov 9, 2019 #7 Mamdouh Elfors said: Please reconsider Click to expand... The attached has the filter I suggested in msg#2. Is it not as required? Attachments Chandoo42987Agri.xlsm 68.9 KB · Views: 2
Mamdouh Elfors said: Please reconsider Click to expand... The attached has the filter I suggested in msg#2. Is it not as required?