I am still learning QS and i have a question. I am trying to create revenue reports for YOY. I need these to run for our fiscal year though. (08/01 - 07/31). I would like to have YTD FY 24, FY 23, and FY 22. My plan was to create calculated field as filters for each fiscal year so I could have them in the same visual. I am running into syntax errors and I am not sure I am even using the correct functions to achieve this.
Questions - 1. are calculated fields the correct way to go about this?
2. could you suggest the functions I should be working with to achieve this?