Issues with subtotal in pivot table expression columns

[#1]

Hi Everyone,

I'm facing some issues with expressions subtotal using pivot table. Actually there are three expression in my table: columns A, B and C where A and B are a result  from a set of data and C is a result from A x B. The subtotal option is set and working nice for A and B (presenting as result a sum of each row from the respective column) , however Column C the result presented in Subtotal, instead of considere a sum from all table rows, the result presented is equal subtotal A  X subtotal B (see example below). Does anyone knows how to solve it?  I mean, make  subtotal from C be equal C rows' sum, instead of be equal  subtotal "A"  times  subtotal "B" ?

thanks in advance,

Fayad

[satishkurra]

Go to presentation tab, select all the required dimensions and check Show Partial Sum option....

[#3]

Hi Satish,

this option has already been checked properly. The issue is not a missing values, but the result is assuming the  expression's formula from column C (column A x Column B)and not the sum of  the rows from column C

[hic]

Sum(Aggr(<A>*<B>, Dim1, Dim2, Dim3 ))

where <A> and <B> should be the appropriate aggregations, e.g. Sum(x) or whatever you have.

Or you switch to a straight table and change the total mode to "Sum of Rows" (Presentation tab)

HIC

[#5]

It is perfect.

Thank you !!