Skip to Content
Former Member
Nov 16, 2010 at 12:26 PM

Exchangeable measures


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.