James_Clark Member

Comments

  • Lots of ways to do this, but basically, you want to join the data from the Date To column to the Date From column. Then you need to rename the Units Sold to Last Period Units Sold, and the Retail to the Last Period Retail. This will add the extra column you are wanting. Not sure what package or permissions you have in your…
    in How to get Last Week/Last Year/etc through dataflows Comment by James_Clark March 2023
Avatar