Previous Parallel column appears missing when current column is missing

MGOropeza — Mon, 11 Feb 2019 19:16:33 GMT

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

Re: Previous Parallel column appears missing when current column is missing

Madelyn_SAS — Thu, 14 Mar 2019 20:27:34 GMT

Does this blog help?

SAS Visual Analytics filters on periodic calculations: Apply them or ignore them

topic Re: Previous Parallel column appears missing when current column is missing in SAS Visual Analytics

Previous Parallel column appears missing when current column is missing

Re: Previous Parallel column appears missing when current column is missing