Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think got it to do what you need
Go to the Style tab and check the indent mode like this
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
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.
You can use dimensionality() to redefine the Totals in your pivot table.
I created an example. Take a look.
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)]
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.
=If (dimensionality() =1 , DIM1) dont work. Nor =If (dimensionality() =1 , only(DIM1))
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.
Is that what you want?