Hi, I have a P&L matrix with account codes for revenue and costs on the rows, I have my months on my columns with my measure for the values and this works well. But i now want to show YTD Actuals, YTD budget & YTD Variance columns at the end of my matrix but when i put my measure into my matrix it puts the values under each individual month rather than displaying single columns at the end of my matrix. I’ve searched on google and on this forum but haven’t found a solutions yet.
I then thought about creating a new matrix to the side just with the YTD, YTD BUD and YTD Variance columns in this matrix, this works until i need to scroll down as the P&L has many accounts, as one matrix scrolls down but the other stays the same so this doesn’t fully work, can you sync scroll bars for two matrix?
Any help with best option would be appreciated.