reorder columns in a matrix

[AJPF]

Hello all, 

I have a simple matrix showing three variables (number of starts "S", number retained "R" and number passed "P") split by two other variables (curriculum area and age group). 

It currently looks like this: 

Age group           16-18            19+              Total

Curr Area           S    R    P      S    R    P      S    R    P   

Education           10    8   6      15   12   10     25   20   16

Arts                20   13   9      45   40   35     65   53   44

Computing           30   25  21      10    5    3     40   30   24

Total               60   46  36      70   57   48    130  103   84

I would like, if possible, to reorder the columns so it looks this: 

Age group           S             R              P

Curr Area           16-18  19+    16-18  19+     16-18  19+ 

Education           10     15      8     12       6     10

Arts                20     45     13     40       9     35

Computing           30     20     25      5      21      3

Total               60     70     46     57      36     48

Is this possible?  I don't need the Total column in the new version. 

Thank you

[Anonymous]

Hi @AJPF 

Please check https://cloudbi.com.au/calculation-groups-use-cases-power-bi-matrix/  this might help you

Regards,

Husna

[AJPF]

I've read Ali's post but, unless I'm missing something, I'm not sure that it helps. 

His matrix only had one values variable - Sales Amount - but mine has three. 

[v-deddai1-msft]

Hi @AJPF ,

Would you please show us sample pbix ?Then we can help you more accurately.

Best Regards,

Dedmon Dai