I have made combined Analysis from three (3) different subject areas. Lets name them subject 1, 2 and 3.

Subjects 1 and 2 has same kind of data in them, working with pieces and costs of them. Subject 3 contains data of working hours and cost of them.

All of these subject areas are combined with "Union". Question is, how can I exclude zero/null values from pivot table.

In attachment Subjects 1 and 2 are in blue color and Subject 3 in red color.

Is there a way to remove those zero or null rows leaving Dep. 1, 4 and 5 to Scrapped, Total Cost, Scrap pros and Dep. 2, 3 and 6 to Rework time, Rework €.

I have checked properties of Analysis, View, Column and it seems I can not find any properties to not include null values.

I also tried to build different types of filters but they didn't seem to work either because of difference between Department names as the data is different between Subject areas 1-2 and Subject area 3.

Is it even possible to do or am I just wasting my time?