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
... View more