Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I would like to put the decomposition of a dimension in a Pivot Table where there are other dimensions:
Here the expression 'A' in the third line is composition by a other dimension names 'T'
How can i add the dimension 'T' in this Pivot Table with a '+' like the columns to see the decomposition ?
Thank you in advance for your help,
Sébastien.
I am not sure I understand.
If you want to group by your expressions to a finer granularity, put the dimensions into the dimension tab.
You can pivot dimensions to the top or to the left, just as needed. If more than one dimension is available on the top / left of your chart, you can expand / collapse the columns / rows by using the small '+' button.
These dimensions will basically affect all expressions, stating a GROUP BY clause for your aggregations.
Thanks for your response but i would like to have the decomposition only on the expression 'A'.
Than is it possible to have '+' on the columns and the rows on the same time ?
Sébastien.