Hi All,
I am creating a crosstab object in SAS VA 7.4 that must present with a category hierarchy a Total Amount and a Total Amount (previous parallel period) columns.
The issue occurs when current month does not have data rows doing drill down, the Total Amount (previous parallel period)column present missing and it has data.
I have validate missing trying to convert in zero, but the thing is that the row missing does not exist on data.
The subtotals are ok but the missing in Total Amount(previous parallel period) is not correct.
Can anybody help me to find a way to show correctly in this table Total Amount(previous parallel period) column?
Thanks in advance
Does this blog help?
SAS Visual Analytics filters on periodic calculations: Apply them or ignore them
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.