09-10-2016 02:32 AM
I have a drop-down control in my dasboard which contains the quarters of a year (text). Further I have a cross tab with the
cashflows of the chosen period. In the cross tab I want to compare the chosen period with a previous period but here I get stuck
and I tried to search the internet but could not find the selution.
I hope that someone can help me.
09-12-2016 10:43 AM
SAS Visual Analytics enables you to create many different derived calculated data items such as "difference from previous parallel period." The documentation is here:
09-12-2016 04:26 PM
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 = 8) return cashflow else 0
But then I get when previous period = 8 only the cashflows based on the filter from the drop-downlist.