Totals on pivot

[Shiva123]

hi,

      everybody i am trying to get to totals on pivot table, i enabled partial sum but still it is not displaying, but it is displaying when i convert it to straight table and i even tried the aggr function with all the  dimensions in the expression due to complexity of the expression the dashboard is hanging up i even tried creating the pivot table from scratch it is not working.   So what could be the best way to get totals .

Thanks in advance

[Shiva123]

i tried  with the straight table and it was working fine . but the view which is generated by the straight table is not the thing which users  expect . i even tried by making the dimensions as horizontal in straight table , but  in straight table all the dimensions are moving to horizontal instead  of one dimension . i even used the function Sum(Aggr(Your Expression, YourDimensions)) as you know it slows down the apps as it has many aggr functions in the expression . is there any possible solution for this .

[sunny_talwar]

is there any possible solution for this .

Already told you that you need to simplify your expression.... not sure what else you want me to tell you

[Shiva123]

hey sunny i did change the expression  to , total<month, period_yyyy> but still i am not getting totals .. the performance of dashboard is better when i changed it to total rather than aggr(no distinct )

[Sergey_Shuklin]

Hello, Shiva!

I'd faced such problem not so far when I start using QV12. When I closed my project and opened it again the partial sums had appeared, so it may be a bug of 12 version.