Based on my requirement I have to find out the previous month Amount for same year. I have to show Current month and previous month amount in List or Cross table. On Table I have applied filter ( MMMYY & DepartmentName) based on Parameter. For This I have created new column by right click the column ‘Amount’ (Difference from Previous Period). When I am not using any filter on List table on Report canvas then both value showing in list once I am applying filter ( MMMYY & DepartmentName) the value for new column (Difference from Previous Period) is not coming. Below code has been generated automatically for new column (Difference from Previous Period) RelativePeriod(_Sum_, ' Amount 'n, 'DEPLOY_DATE'n, _Inferred_, 0, _Full_, {Date}) - RelativePeriod(_Sum_, ' Amount 'n, 'DEPLOY_DATE'n, _Inferred_, -1, _Full_, {Date}) I have replace '_SUM_ ' and '_Inferred_' By '_Average_' and '_ByMonth_' respectively. but nothing change in result RelativePeriod(_Average_, '%'n, 'DEPLOY_DATE'n, _ByMonth_, 0, _Full_, {Date}) - RelativePeriod(_Average_, '%'n, 'DEPLOY_DATE'n, _ByMonth_, -1, _Full_, {Date}) I think its aggregated column which not works when I am applying filter on object. Could you please suggest how can I calculate previous month value (not Aggregated measure) so I can easy use it in any object (list or cross table) where I have used filter. Regards, Anand
... View more