Hi,

I am getting wrong data when removing columns with zeroes.

For example a I have the following raw data for purchasing:

Article Vendor Qty_PY Qty_CY

A1..............V1............5...........7

A2..............V1............8...........0

A3..............V1............2...........1

And I want to display current year qty by article on columns, with a result column on the right showing Total Qty Current Year and Total Qty Previous Year.

Vendor A1 A2 A3 Total_Qty_CY Total_Qty_PY

V1.........7....0....1....................8....................15

But we want to remove columns with zeroes like A2. This is the output we would like to get:

Vendor A1 A3 Total_Qty_CY Total_Qty_PY

V1.........7....1.....................8...................15

As you can see only A1 and A3 have displayed as there are no purchases on A2 on previous year. But I need to show A2 quantities in Total_Qty_PY.

I managed to make it uncheking "Show rows for which all measure values = 0" table option. But it is not working properly because it is filtering out A2 quantities. This is what I get:

Vendor A1 A3 Total_Qty_CY Total_Qty_PY

V1.........7....1.....................8......................7

I tried using NoFilter() function on Total_Qty_PY, but we have filters on filter bar. So when applying a filter on any dimension it will not apply on Total_Qty_PY.

Any suggestion?

Thanks in advance,

Abraham