Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I'm using Pivot table and I'm looking for solution below:
if Average Demand = „0“ and Actual Inventory Available = 0 and Actual Inventory Value= “0” then don’t show the Material number in the report.
I'm trying something like below , but not working
=IF( not isnull(ACTUAL_INV_VAL) and not isnull(ACTUAL_INV_QTY) and not isnull(AVG_DEMAND), Material_MATNR, NULL())
Thanks,
AS
Hi,
Don't use this in dimension, try the way I provided in my earlier post, if all the rows returns 0/null then the Material number automatically removed when you supress 0 and Null values in the Presentation tab.
Regards,
Jagan.
Hi,
Try if(sum of all three <>0,field,0).
Any help ????
Not working!
Hi,
You need to use this condtion in all the expressions
=IF( [Average Demand] = 0 and [Actual Inventory Available] = 0 and [Actual Inventory Value= 0], Your Expression Goes here)
Note : If all expressions returns 0 in a row then that is automatically removed, to do this we are using above If().
Hope this helps you.
Regards,
Jagan.
Also check the properties of you object:
Chart Properties -> Dimensions
- Suppress When Values is NULL should be marked
- Show All Values should be unmarked.
Hi Jagan,
Please see the attachment , I tried few things but still looks like approach is wrong.
Kindly help if possible.
Thanks,
AS
Hi amit,
try to use conditional show, but not sure, if it would fulfill your requirement.
Hi Amit,
Please find attached file for solution, I implemented only for Currency column, do the same for remaining columns and check the presentation tab for changes.
Regards,
Jagan.
Hi Jagan,
Thanks for your response ,Just one question:
If(Column(1) >0 AND Column(2) > 0 AND Column(3) > 3,
CURRENCY, Null())
This Column(3) > 3 should be Column(3) > 0???
Thanks,
AS