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