Hi, I have a pivot table. Can I get the average of the last 13 records for each column?
Average by per1 column
Go to Solution.
Average Last 13 =
Change the red to match your tables and columns!
You can add a matrix with just the columns and the new measure.
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!