Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created a pivot table with 1 row dimension (Country), and as the column dimension I use value list with 4 values.
3 values are based on table 1
1 value is based on table 2
The tables are not linked together.
I would like to have my measures calculated on Country(Table 1) for the first 3 values
And the measure for the 4th value based on Country (Table 2).
How can I create a dynamic dimension which essentially includes Country(Table 1)&Country(Table 2)?
Thanks.