Skip to Content

Incorrect data with Zero suppression in Webi

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 07 at 03:47 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07 at 04:35 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded