Previous Parallel column appears missing when current column is missing

[MGOropeza]

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 

[Madelyn_SAS]

Does this blog help? 

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