Thank you for your reply. The problem is that the derived calculated items are limited. The cashflow in the crosstab is based on a text filter (drop-downlist control) for example 'Q1 2016' and I want to compare this with the cashflows 'Q4-2015' in the same crosstab. So entirely not based on a date. Probably the answer is a calculated data item with something like:
if (previous period = 😎 return cashflow else 0
But then I get when previous period = 8 only the cashflows based on the filter from the drop-downlist.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.