check in the attached...
instead of doing a calculation for each measure, I did two filters, one for the Year and one for the Month, and use the same SUM(measures) on both sheets.
Thank you, Michel! I appreciate your solution not only because it works, but because it is much simpler than the original design. Not having to create all those extras calculated fields sure cleans things up in the actual workbook.
I have one more question regarding this same workbook. I two other worksheets that are MOM/YOY changes, not included in the first workbook. I have now included a mockup of the MOM worksheet as well. I was hoping to be able to use your same Month Filter and Year Filter for these worksheets, but it gives me an undesirable view.
I need both months or the calculations do not return the percent change, but I only want to see the most recent month on the screen. Previously, I was using Last() as a filter, but it does not work after the user makes their selection.
Can you think of a way to have the calculations work, but only show one column?
Updated workbook attached...