My companies fiscal quarter for the year 2020 do not start exactly on the first of every month, I was wondering how I can display data using these dates. For example I want a revenue vs quarter visual, so I want to see how much revenue there is for each quarter. Although I do not know how to make a custom calculate member for this.
Also the default fiscal quarter pulls from the “creation date” and I want it to pull from “booking date” when it displays the quarters for revenue.
Q1 : August 28 - October 26
Q2: November 27 - January 25
Q3: Feburary 26 - April 25
Q4: May 26 - July 25