Use Dimension element as Total label ?

[#1]

Below Niveau3 elements sums up to 'Resultat' in Niveau4.

I have renamed Total label to blank, and right aligned Niveau4.

Is it possible to combine Total cell with Niveau3 'Resultat' like I have done below in excel?

Kind regards

Jerrik Walløe

Coop Denmark

[Gysbert_Wassenaar]

No, that's not possible. The total label can only have one value for the entire dimension column. But you can create a new field in the script and use that as dimension. See here for an example: Custom Labels in Pivot Table

[#3]

I had a look at the linked solution. It may work in small scale, but my hierachy is big and not static.

I hope for other solutions. Total labels can be filled with Dimension element text, in others BI tools. So perhaps QV also.

[iktrayanov]

You can use dimensionality() to redefine the Totals in your pivot table.

[iktrayanov]

I created an example. Take a look.

[#6]

Label for grandtotal is changed, but could the label for subtotal be changed?

For Dim2 I tried to set [Label for total] to [=Before(DIM1)] but then just '-' are displayed. Same for [=Only(Dim1)]

[iktrayanov]

You can change the label for subtotals by using

If (dimensionality() = 1, .... Notice that the dimensionality for normal cell is =2 for subtotals is =1 and for grand total is =0. Using that you can redefine what is shown in any of the cells.

[#8]

=If (dimensionality() =1 , DIM1) dont work. Nor =If (dimensionality() =1 , only(DIM1))

[iktrayanov]

Where are you using this in the total label or in the expression?

Can you explain in more detail what you are trying to do so I can try to help.

[iktrayanov]

Is that what you want?