Skip to Content
0

Incorrect data with Zero suppression in Webi

Feb 07 at 03:23 PM

32

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Feb 07 at 03:47 PM
0

Follow these steps.

Uncheck the option "Show columns for which all measure values = 0"

After that apply nofilter on Total_Qty_PY column.=NoFilter([Qty_PY])

See attached.


untitled.png (20.6 kB)
Share
10 |10000 characters needed characters left characters exceeded
Abraham Bujedo Feb 07 at 04:35 PM
0

Hi Amit,

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.

For instance, if we select one plant in the filter bar, we get the same value on Total_Qty_PY and it should show the value for the selected plant only.

We cannot use NoFilter().

Thanks and Regards.

Share
10 |10000 characters needed characters left characters exceeded