Grand total and subtotal issue in Pivot table

[Srinivas]

Hi All,

I have small issue in Pivot and Straight table , Pivot table not calculate the exact total value and straight table will give the exact total value ,

Please see below screen shots:

Please find the sample Qvw.

Advance Thanks

Srinivas

[sunny_talwar]

Try this expression in pivot table:

Sum(Aggr(sum([Sales Quantity])/1000, Country, [Item Number]))

[MayilVahanan]

Hi

Try like this

Pivot table expression

If(Isnull(rowno()), Sum(Aggr(Sum([Sales Quantity])/1000, Country, [Item Number])) , sum([Sales Quantity])/1000)

[jonas_rezende]

Hi, munnareddy

Utilize aggr() function in Pivot Table for that expression be calculeted of  total shape. How Total Mode in Expression Tab is disabled in this object, you need Sum(), different of Straight Table. Follow expression below:

Sum(

  Aggr(

       sum([Sales Quantity])/1000

  ,Country

  )

)

Hope this helps!

[Srinivas]

Hi Sunny,

In my main application have around 25 dimensions, Any other solution without aggr  and group by functions.

Regards

Srinivas

[sunny_talwar]

There might be one, but I am not aware of one