Are you looking for the running total of Price Impact as each month is displayed? With your sample workbook I set the table calculation on Price Imp to Running Total, then dragged the Price Imp pill onto Measure Names again to get those results.
1. Set Price Imp pill in Measure Names to Running Total. You have to do this first because you cannot have the same pill in Measure Names twice, unless they are a different aggregation or have a table calculation.
2. Drag Price Imp into Measure Names so you can display the Price Imp per month
PriceImpact.twbx 43.0 KB
Hi Aaron Dobbins,
thank you for your answer, unfortunately that's not what I am trying to achieve.
First of all I am not looking for the running total of "PriceImp CF" but for the simple sum by month as reported in the second table of my original post.
Secondly, and more relevant, I need to use the calculated field - "PriceImp CF" - rather than "Price Imp" as the later is not available in my original data source and is provided for comparison reasons only as indicated in my post.
Thank you for taking the time anyway.