Question

Can measure's be placed only at the end of the look

  • 25 January 2017
  • 3 replies
  • 160 views

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?


3 replies

Userlevel 3

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.

Userlevel 3

Hi,


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.


Andy

Reply