how to switch two columns in matrix based on slicer value

[Anonymous]

here is sample data

dim1	dim2_1	dim2_2	dim3_1	dim3_2	value
Earth	Euro	Asia	Euro1	Asia1	165
Earth	Euro	Asia	Euro2	Asia2	54
Earth	Euro	Asia	Euro3	Asia3	96
Earth	Euro	Asia	Euro1	Asia4	100
Earth	Euro	Asia	Euro2	Asia1	100
Earth	Euro	Asia	Euro3	Asia2	136
Earth	Euro	Asia	Euro1	Asia3	91
Earth	Euro	Asia	Euro2	Asia4	57
Earth	Euro	Asia	Euro3	Asia1	118
Earth	Euro	Asia	Euro1	Asia2	150
Earth	Euro	Asia	Euro2	Asia3	112
Earth	Euro	Asia	Euro3	Asia4	154

I want to create a matrix to put dim1 in column1, dim2_1 or dim2_2 in column 2, and dim3_1 or dim3_2 in column 3,

and it should be added a slicer that it's value is 11, 12, 21,22:

if slicer=11 then column2=dim2_1 and column3=dim3_1,

if slicer=21 then column2=dim2_2 and column3=dim3_1,

if slicer=12 then column2=dim2_1 and column3=dim3_2,

if slicer=22 then column2=dim2_2 and column3=dim3_2,

do you know how to make it? Thanks.

[olgad]

Hi, check this article of mine on how to do measure groups/column groups.

https://www.linkedin.com/pulse/field-parameters-case-measure-groups-olga-dontsova/?trackingId=IX8BrZ...