Exchangeable measures

[Former Member]

Hi Everydoby,

I have following data:

- 2 dimensions u2013 weeks, regions

- 5 measures u2013 orders, invoices, credits, debits, order responses

I want to create 1 crosstab where I will have weeks in rows, regions in columns and one of the measures will be the actual data to show in crosstab.

And here comes the tricky part. Instead of creating 5 different tables for each measure, I would like to create only 1 crosstab with weeks, regions and exchangeable measure. So for example I will create a new filter with all 5 measures and the crosstab will show data depending on selection in this filter.

Is something like this even possible?

Iu2019ll appreciate any ideas.

Martin

[amrsalem1983 · Accepted solution]

yes its possible. you can do it easly, but you need some more dimension in your universe

this dimension will prompt the user for values 1,2,3,4,5

lets name it (P_whichMeasure)

and in your cross tab you can make the weeks in rows and the regions in columns and you measure will be like this

=if([P_whichMeasure]=1;[measure1];if([P_whichMeasure]=2;[measure2]...........................................;[measuer5]);

i hope you got the idea, its not complex but tricky.

good luck

Amr

[Former Member · Accepted solution]

Hi Amr,

Thanks a lot for your answer. I got the point and I believe it'll work.

Best Regards,

Martin