CODEWITHSUNDEEP
activepivot
Anders Blaagaard
Anders Blaagaard

Reputation: 145

Is it possible to show totals last in Active Pivot Live?

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

Upvotes: 2

Views: 225

Answers (3)

Jack
Jack

Reputation: 145

You can use this expression:

Hierarchize(Set_Expression , POST)

instead of

Hierarchize(Set_Expression)

in your Mdx query.

Upvotes: 0

JBE
JBE

Reputation: 12597

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

Upvotes: 0

user2606049
user2606049

Reputation:

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.

Upvotes: 1

Related Questions