Column header sorting in multi dimensional Matrix

[sanju_g]

I am using Multidimensional Matrix where I have Fiscal Month as 1st Level and for each Fiscal Month I have Actual and Budget numbers. I am using excel data for this report.

In second level, by default, the header are displaying as Actual (First) and Budget (Second), I want to display Budget (First) and then Actual (Second). Is there any way to do the column sorting. There is some option of Column sorting in Modelling Menu option, but that is disabled.

[v-frfei-msft]

Hi @sanju_g,

Could you please share your sample data and excepted result to me ? So that I can help with it.

Regards,

Frank

[sanju_g]

---

---

---

Hello,

Below is by data format. If you see row 2 below where it says Actual & Budget for each Fiscal Month. I want this to be Budget and Actual, instead of the way it displayed.

Fiscal Period	201801	201802	201803	201804
Initiative Id	Actual	Budget	Actual	Budget	Actual	Budget	Actual	Budget
C00021	311233	331124	55413	331124	62567	331124
D00555-2	2264794		-7188687
D00555-3
D00440
D00646

Thanks & Regards,

Sanjeev