Displaying data for last fiscal week of the Year/Quarter/Month

I have a barchart with a binned time hierarchy at the category axis.
There is a detailed table visualization in the next page for the bar chart.
When I select year in the bin hierarchy I have two stacked bars for years 2016 and 2017 each.
Requirement is when I mark bar for year 2016 in the chart then the data for last fiscal week of the year should be displayed in the details table.
When I mark both the bars then data for the last fiscal week of each year should be displayed.
Similarly when i select quarter in the category axis(bin) and mark any one of the quarters then the data for the last fiscal week in that quarter should be displayed and when i mark the all the quarters then the data for last fiscal week of all the quarters should be displayed.
And, likewise for months last fiscal week of the selected month and when all months are marked then last fiscal week of every month.

(1) Answer

Login