I am trying to add ROW subtotal for each year for each measure. For the Measure Baseline, i need sum of 2018 values which sum up to $11,000 and then sum of 2019 is $5000 (In green)
This is difficult to answer without seeing the structure of your data. Any chance you could upload a packaged workbook?
Since the file had restricted information,ive replicated the situation on sample store data... the green part is the expected output i need (for all the measures chosen)
please see the file attached..
Retrieving data ...