Hi All,
Greetings for the day.
I have one requirement in my dashboard. I have four buttons YTD, Full years, Pyear,Quarter.
I need to display different data for these buttons in different tables. Below is the description.
Actually my fiscal year starts from November.
YTD - If i click on this button it sholud disply data for all completed quarters for current year and last 2 years.
Ex : If we are in second month of third quarter then it should display data for First two quarters of current year and same for last two years.
Full Years - It should display data only for completed years i.e not present year (we are in 2015 Q3 then it should display data for 2014,2013).
PYear - If we enter into second half of the year then it should display data for first 6 months of current year as well as previous 2 years.
Quarter - It should display data for last 9 quarters but not current Quarter
From last 2 days i'm trying to find the solution using set analysis but i am unable to find exact solution.
I have attached sample QVW also.
Thanks
