Yep, I did that ZZ!
I want to build a table of all the columns mentioned and using just one user parameter. I want to give the user to input only one date in mm/dd/yyyy format and my datasource has date and country mappings using which i want to construct a fiscal summary table. It should be a table full of calculations and not by default tableau options.
This helps and i already did this. But - my objective here is a bit different.
How do i calculate H1 and Fiscal year nos. if my fiscal year start is April to March.
Suppose i have 5 years data and I want one input thru parameter from my user as a date in mm/dd/yyyy format. And basis this input, how do i calculate my H1 and Fiscal year nos. If user passes a parameter as say 06/01/2018 - He should get a table with:
1. YTD nos. of June'18
2. MTD nos. till June'18 - i.e. from April'18 to June'18
3. PYMTD nos till June'17 - i.e. from April'17 to June'17
4. H1 nos of year(Parameter_Date) i.e. April'18 to Sept'18
5. Full fiscal year(Parameter_Date) - i.e. April'18 to Mar'19 nos.