2

Feels like I'm asking something very obvious, but I can't seem to find a configuration for showing 'Grand Total' last (bottom or right) instead of first (top or left).

It is the first question asked by new Active Pivot Live users

Infinite Recursion
  • 6,511
  • 28
  • 39
  • 51
Anders Blaagaard
  • 145
  • 6

3 Answers3

1

Actually, you can't have the grand total row/column at the bottom/right hand side of the pivot table like in excel. Someone has already asked for such a behavior but since it's a very rare demand, it is not in our short term roadmap. However, if you express an interest in having such a feature, it can be reconsider.

0

ActivePivot Live only displays the result of your MDX query, as sent by the server. Thus, if you need to display grand totals on the bottom/right of your view, you can do it by modifying your MDX :

  1. exclude the grand totals from your axis
  2. add it with a union or braces at the end
JBE
  • 11,917
  • 7
  • 49
  • 51
0

You can use this expression:

Hierarchize(Set_Expression , POST)

instead of

Hierarchize(Set_Expression)

in your Mdx query.

Jack
  • 145
  • 1
  • 1
  • 11
  • 1
    A little explanation as to why this would help solve the asked question would be useful. – Josh Burgess Nov 14 '14 at 16:17
  • The POST keyword has been supported for the Hierarchize function since ActivePivot 5.1. This puts the grand total at the end of the set. – Jack Nov 25 '14 at 10:42