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

[#2]

Hi ,

Could you plese post your file with some sample data..

[#3]

Hi ,

Could you plese post your file with some sample data..

[#4]

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

[#5]

is the data ok.. or should i attach file??

[#6]

It would be fine if you could attach the File also..

Thanks

[#7]

hi pls give me suggestions

[#8]

Hi,

You have already done with the table where you were not showing the zero values.. May I know what is the requirement that is pending..

Thanks

[#9]

Hi,

You have already done with the table where you were not showing the zero values.. May I know what is the requirement that is pending..

Thanks

[#10]

in this item ID total is not equal to sum of rows displayed. that is my exact problem.