I would like to have a daily dashboard analyzing the daily production and daily growth.
Calculated items using Parallel period and relative period have been created to show count of previous day but it does not reflect properly once the date dimension being taken out from the crosstab table.
When I choose 12/02/2020 in the report filter, the cross table should be showing something as below

| CONVENTIONAL | TAKAFUL | Total |
| CASE_COUNT | Case Count (Day-1) | CASE_COUNT | Case Count (Day-1) | CASE_COUNT | Case Count (Day-1) |
Channel1 | 16 | 30 | 3 | 5 | 19 | 35 |
Channel2 | 15 | 15 | 2 | 3 | 17 | 18 |
Total | 31 | 45 | 5 | 8 | 36 | 53 |
Need S.O.S on this