I need to put an option in my dashboard where in the user can select whether he wants the dashboard to be of a single quarter or of a rolling quarter. A rolling quarter means the average of the past 4 quarters including the current one. I need a way to implement this.
After doing research , I found As of table (The As-Of Table). But I am unable to implement it.