dijous, 22 de novembre del 2012

How to change totals/subtotals position within a crosstab

This post explains how to change the totals/subtotals position within a crosstab.

By default, totals and subtotals are always above their descendants, i.e:
Total
children 1
children 2


To move total positon to the bottom, i.e below, follow these steps:

children 1
children 2
Total


1 - Create a dataitem that retrieves member level and name it Ordinal:
Ordinal(Level(currentMember([..hierarchy])))

2- Change Ordinal dataitem Aggregate Function and Rollup Aggregate Functionn properties to Total

3- Go to the crosstab node member you want to set the new sorting behaviour and add Ordinal to the sorting list with DESC option.

Cap comentari:

Publica un comentari a l'entrada