Column header sorting in multi dimensional Matrix

Question

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 · Answer

Hi&nbsp;sanju_g,&nbsp;Could you please share your sample data and excepted result to me ? So that I can help with it.&nbsp;Regards,Frank

sanju_g · Answer

&nbsp;Hello,&nbsp;Below is by data format. If you see row 2 below where it says Actual &amp; Budget for each Fiscal Month. I want this to be Budget and Actual, instead of the way it displayed.&nbsp;Fiscal Period201801201802201803201804Initiative IdActualBudgetActualBudgetActualBudgetActualBudgetC000213112333311245541333112462567331124&nbsp;&nbsp;D00555-22264794&nbsp;-7188687&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;D00555-3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;D00440&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;D00646&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks &amp; Regards,Sanjeev

Forum Discussion

Column header sorting in multi dimensional Matrix

2 Replies

Related content

Sort by another column

Column Chart sorting

Sorting

Understanding Dimensional Modeling

Table Sort , sort order , comparer

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