Totals are not coming for some fields

[#1]

Hi,

When i created a new pivot chart and applied for partial sums . Some column doesnot show the values and show null values. The rest show corect values.  I am attaching an image of the pivot table..

Could anybody have a look and let me know.

Thanks

Renjith Kumaran

[kaushiknsolanki]

Hi,

   Are you using the aggr function for those expressions?

   If yes then try to put then in sum (Aggr(.....))

Regards,

Kaushik Solanki

[#3]

Kaushik,

I used like this

sum(GradedQty), sum(b) ,,,,

Thanks

Renjith Kumaran

[kaushiknsolanki]

Hi,

     Then I dont think there should be any problem.

     Is it possible for you to upload the qvw file.

Regards,

Kaushik Solanki

[#5]

Hi,

I have used the expression

sum(GradedQty)* ReclaimValue

in which i dont get the partial sum. The rest columns are fine.

Thanks

Renjith Kumaran

[er_mohit]

try this

sum(GradedQty* ReclaimValue)

[nagaiank]

If GradedQty field has null values, use

If(IsNull(GradedQty) or Len(Trim(GradedQty))=0,0,GradedQty)

instead of GradedQty

Also, if Reclaimvalue as null values, use

If(IsNull(ReclaimValue) or Len(Trim(ReclaimValue))=0,0,ReclaimValue)

instead of ReclaimValue

so that null values are replaced by zero.

[kaushiknsolanki]

Hi,

    You can try the both way.

     1. Suggested by Mr. Mohit i.e

sum(GradedQty* ReclaimValue)

     2. sum(GradedQty) * Sum( ReclaimValue)

     Once you use any of the above you will see the Total for sure.

Regards,

Kaushik Solanki