Skip to main content
Solved

Show results in tables and charts as last 365 days

  • 10 January 2022
  • 2 replies
  • 59 views

I am trying to use a pivot table to show the sum of sales of an inventory item over the last 365, or trailing 12 months. Acumaitca only gives me the option of using “@YearStart” and “@YearEnd”. I was wondering if there was a value I could type in from trailing 365 days today.

 

 

It appears this has solved my issue, thank you!


Try something like this:

 


Reply