Dear Community,
I have two data points, Capacity and Demand, which I display monthly on a straight table chart.
Using this data, I have created a simple expression which subtracts Capacity from Demand to calculate under/over utilised in the month. This expression also has 'Full Accumulation' so I can track if there is a building 'Backlog' month on month.
My issue is, I want to calculate and display the rolling the Backlog number but I only want to start displaying the data from a certain month.
To explain further via example, I have Capacity and Demand data from Jan-Dec generating the rolling Backlog through the year but I only want the table to display months from April forward. If I restrict the Month dimension via Calculated Dimension then my expression will not take into account (or see) months Jan-Mar.
The table below illustrates what the full year would look like, but can I display the same numbers but only from Apr onward?
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
|---|
| Demand | 10 | 10 | 5 | 5 | 8 | 10 | 20 | 30 | 10 | 0 | 0 | 0 |
| Capacity | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |
| Backlog | 2 | 4 | 1 | -2 | -2 | 0 | 12 | 34 | 36 | 28 | 20 | 12 |
Does anyone know how I can achieve this requirement? Thank you in advance for any support.
Regards,
Keith
