1. If i choose Quarter Year filter in my sheet, and depending on what Quarter Year i chose in the filter i want the latest Latest week sales of that quarter to be calculated.
2. I also want previous year sales value to be calculated. Previous Quarter Sales depending on what Quarter Year filter i choose.
Say if i choose Q3-2017 , it should display Q2-2017 Sales. If i choose Q1-2017, it should display Q4-2016.
However by default point 1 should display current work week sales in graph 1 and point 2 should display previous Quarter sales in graph 2.
Thanks for the help in advance