1 Reply Latest reply on Feb 10, 2016 8:57 PM by Adam Crahen

    Financial Comparisons - difference calculation from multiple filters

    francesca.tangredi

      I am trying to create a tool that helps us to compare our financial reports. The data is set up as shown in the attached file. The report types are different columns (Budget/Mid-Year/Forecast/Final) and the years and measure names are each a column. I need to be able to on the left side choose a year and a report type, and on the right side choose another year and report type (could be the same or different choices for each field). Then in the middle, I need to be able to create calculations of the Difference and % Difference. I included tabs in the attached excel sheet that should help with the output that I'm looking for.

       

      I have tried this a few different ways so far and the calculations across years seems to be the difficulty. Any advice would be much appreciated!