Skip to main content
Solved

Show results in tables and charts as last 365 days

  • January 10, 2022
  • 2 replies
  • 74 views

Forum|alt.badge.img

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.

 

 

Best answer by Neil Cantral

Try something like this:

 

2 replies

Neil Cantral
Jr Varsity I
Forum|alt.badge.img+3
  • Jr Varsity I
  • Answer
  • January 10, 2022

Try something like this:

 


Forum|alt.badge.img
  • Author
  • Freshman II
  • January 10, 2022

It appears this has solved my issue, thank you!