I suppose my question is two-part:
1. How is the best way to determine each month for the last 12 months from a max date in a column?
2. I would like to create a pivot using those dynamically-determined 12 months. It does not look like GROUPSELECT is a function that can be used dynamically for a pivot. Is the pivot widget the only option for this?
Thank you in advance.
Please sign in to leave a comment.