Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a maximum number of dimensions in a pivot table? in case I create a pivot table with about 15 dimensions and one expression the last dimensions are displayed at the end of the table, after the expression.
Is there a way to display all the dimension before the expression?
Thanks, Lucia
You can absolutely do that. and you need not do any special settings for that.
If in case our dimensions are coming after expression, you can move the dimensions...just drag and drop/
Hi,
In pivot table first the dimension will be displayed and later at last only the expression will be displayed.
if you want to create dimesion after expression
you can create expression after all the expressions and give expression lik this
=Fieldname
then yu will get dimension after expression
You can absolutely do that. and you need not do any special settings for that.
If in case our dimensions are coming after expression, you can move the dimensions...just drag and drop/
Hi Lucia,
We can do that. Follow the Gowtham's advise. Thank you.