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
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.
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.