How to exclude null values when working with three different subject areas

2961970

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?

SriniVEERAVALLI

you need to write outer query based on all those union clause as inner query and can exclude nulls or zeros

but this might need to recreate whole report formatting and headings etc