Pivot Chart sub total value details

[#1]

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.

Thanks

Kumar

[rohit214]

hi

try this

in Script:

if(Qty=0 0r isnull(Qty='-1'),'0','1') as Flag

in expression:

sum(Qty*Flag)

Sum(Value*Flag)

may it hepls you

thanks

rohit

[#3]

flag expression is giving error

pls chk.

rgds

kumar

[#4]

Hi,

try this..

if(Qty=0 0r isnull(Qty),'0','1') as Flag

Hope that is fine...

[#5]

Hi,

try this..

if(Qty=0 0r isnull(Qty),'0','1') as Flag

Hope that is fine...

[#6]

while reloading it is showing error.

kumar

[#7]

The expression is correct only .. unless u have the Qty field in the table it will throw an error..

* if(Qty=0 0r isnull(Qty='-1'),'0','1') as Flag

[#8]

while reloading expr is giving error

kumar

[#9]

pls give me sugesstions

kumar