Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In Pivot chart, I have dimension (location,item) , expressions(quantity,value). Here, I have value but quantity is zero for some items. I need to cut this value when quantity is zero. after that sub total(show partial columns - by checked) is having the total value(including value of zero quantity). So please give me suggestions.
my expression for Qunatity is == sum(PQTY-MQTY)
my expression for Value is == sum(PSTOCKVALUE-MSTOCKVALUE)
Expecting your reply.
kumar
Does this help?
Kiran.
YES. PLZ HELP ME.
KUMAR
pls give sugesstons
kumar
Please check out the attachment I included.