BookmarkSubscribeRSS Feed
Adelaida
Fluorite | Level 6

Dear all,
Our client needs a VA report with the actual sales and previous year sales based on retail 445 calendar.
He needs to see monday's (4.01.2014) sales (first day of week 1, 2016) in parallel with monday's ( 5.01.2015) sales (first day of week 1, 2015), and so on.
And all must be aggregate on a hierarchy made of Retail Year/Retail month/Retail week/Day of week(Date) . We have build a calendar tabel that have for each day the retail year, retail month, week of the year and the corresponding date of previous year.
Is there any way of calculating previous year sales using ParallelPeriod function or a self join or another formula on frontend? Or the only possibility to give him this numbers is to build the fact table with previous year sales precalculated?
Thank you in advance,

Adelaida

1 REPLY 1
Sam_SAS
SAS Employee

Hi Adelaida,

 

The ParallelPeriod operator only uses a standard calendar year (or quarter or month).

 

Possibly in a future release we could add support for more types of time periods. The development team is looking into it.

 

Thanks,

Sam

 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 1 reply
  • 904 views
  • 0 likes
  • 2 in conversation