I have one report where i wanted to display the measure filed in between two dimension fields but the look does not allow me to move the measures filed. Does it mean measure can be places only at the end?
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
That’s correct as far as we have been able to achieve which has resulted in more than a few workarounds for reporting use cases
If you really need the measure column in between the two dimension columns, the best way would be to create a derived table with those columns - which would effectively turn your measure into a dimension. You could then order your (now three) dimensions in the way you want.
The best way to achieve this is to create calculated fields that equal each dimension and measure, you can then freely move the calculated fields around and put the measure between the dimensions. You’ll need to hide the original dimensions and measures from your report however.