Hi, I have created a matrix that compares Monthly Actuals to Monthly Budgets. When I add Month Name to Columns the data is sorted by Actuals and Budgets for each Month Name. Is there a way to group all the Actuals Values together, then all the Budgets Values together so that the matrix shows the Actual Values for Jan, Feb, Mar etc followed by The Budget Values for Jan, Feb, Mar etc.
I have been struggling with this for a while, and I have resorted to 2 matrixes which is obviously not ideal. Is there a better way of doing this, any help is greatly appreciated.