value of previous day using relative period without date dimension on cross table does not show

[nic2]

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

[Sam_SAS]

Hello,

When you use an aggregated measure with a periodic operator like RelativePeriod, the date column must be assigned to the report object. It is expected that removing the date column causes the aggregated measure to return missing.

Sam