I have a dataset which contain 3 yeas records, the structure below   Company  DateTime   Amount   In VA, i duplicate the datetime column and make it a Month Year only column.    I want to build a aging report which show 1 years records from todate to the date 1 year before.  Example August/2019 - August/2018.  The record before August/2018 will sum up and show in one column.  The Month Year column will change when the month is change.  Example if it is September, the report will from September/2019 - Sept/2018.   Here is the table I wish to show to user.     is it possible to do in SAS VA?  Please guide me.  I'm using SAS VA(8.3.1) on SAS Viya(V03.04)   Thanks. ... View more

I want to create my barchart which able to drill down to week of Year from the Year > Month > week of Year.  I have Reference date column in DDMMMMYYYY format and have Amount column.  I drag the bar chart to the designer, at the right pane, I choose role and assign Reference date in Categories and asign Amount i Measure. How I can set my Reference date in categories just show year, then click to drill down to Month then to week of the year?   I try to duplicate Reference date column and change the duplicate column format to Year.  But I got no idea how make it drill down.   Please guide me.  Thanks ... View more