When looking at the composition in terms of accumulation or subtraction from the TOTAL, a good option for representation is the waterfall chart. If the only important differences are the relative differences, then write your calculation as a percentage of TOTAL.
To achieve this, perform the following steps:
- Replace the Sales expression from the preceding recipe with the following:
Sum(Sales) / sum( TOTAL <Month> Sales).
- Once we define the preceding measure, we will notice that just below the expression box for the measure, we get a dropdown for Number formatting. Under this dropdown, change the number format to Number. Next, we define the exact format of the number. To do this, switch off Custom formatting and then, under the dropdown below that, select the Formatting representation as 12%. This will produce the following 100 percent stacked area chart:
