I am hoping this is really simple and I am missing something really obvious....
Dimensional using Transformer Cube.
I have a 2 multiple selection prompts each to select a Groups of Stores (prompt is at Store Level).
Parameters are p_TestStores and p_ControlStores
I simply need to create two member sets of Stores (TEST and CONTROL) and place as Crosstab Column Headers.
Any help would be greatly appreciated.
Thanks in advance,
Adam.
Issue resolved... knew it would be simple.
Created two calculations
set([Stores] ->?p_TestStores?)
set([Stores] ->?p_ControlStores?)
Then used aggregate(currentMeasure within set ([New Calcs]) to get what I needed!