Pivot table: Move measures to rows

[Tommmy]

Hi experts

I have a pivot table with two measures. Can you move measures to the rows and dimensions to the column side?

Thanks for your help!

[Andrei_Cusnir]

Hello,

I believe that your use case scenario most probably is not supported. Row and Column is found under "Dimension", while Values is found under "Measures". This means that you can't use measures as dimension, otherwise you will get "Invalid dimension" error.

Here is an example:

Using dimension:

Using measure:

As you can see, you are getting an error message "Invalid dimension". Unless somebody else was able to find a workaround and can share it here, I assume that the only thing you can try is:

1. In Data load editor use the measure to create a new calculated dimension
2. Then you can use the new field as dimension and load some data as rows (if needed) to use them as measure etc.

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members. 
 

[Or · Accepted solution]

I actually wanted to do this on my end recently and was surprised that it was both available and trivial - one simply has to drag the "Values" box over to the left (Dimension) side and the dimensions over to the Column (measure) side: