If I add ALL(Plan_Period[Date]) the table fails to display at all.
This only works when I select period for December, which is logical but not the required result.
missing FY_Budget as not DecCorrect value with Dec selected
Attempt 2, columns FY_Budget & FY_Budget2
FY_Budget it is correct for December only & FY_Budget2 in the matrix table it displays for each month but the matrix multiply's it and the displayed amount is inorrect.
I have tried don't summarize and creating a duplicate table without a join to the period table but that didn't work and I am now out of ideas. I thought the matrix would just display the column as is particularly for FY_Budget2 but it's multiplying it, so IDK.