Pivot chart sub total conditions

[#1]

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.

Location         Item                 Qty           Value

Stores            Apple              5                   10

                     orange             12                  15

                       banana           0                    3

                       grapes            0                     2

                      pineapple          2                   6

                      total                19                  36

i need           

                      total                19                  31

Thanks

Kumar

[#2]

this is correct. but for my case, i need to put sum() inside IF cndtion that "PSTOCKVALUE-MSTOCKVALUE".

so tat inside values will be correct.

Kumar

[#3]

pls find attachmnt

[its_anandrjs]

Hi,

It is correct in chart Stock 3 it is correct.

Rgds

Anand

[#5]

but dispayed records total is not equal to sub total.

pls chk.

Kumar

[rohit214]

hi

use flag in your edit script

thanks

rohit

[#7]

while reloading it is showing error. i checked in expression it is showing error for isnull().

[#8]

pls give me sugesstions

kumar