Hi Folks ,
I have a scenario, where i have a data set with start, End, Status and ID.
Start date acts a Filter with year, Month, Quarter.
when i make any selections on the filters i want to capture the monthend and and look for that end date between the start and end date from the duplicate table and show the count on the chart.
for that i created a duplicate table so that i can get all the count,
when 2016 is selected, i want to take the max monthend start date and use that date to check the duplicate table , and see if the dates is between start and end dates and get the count
when 2016 and 2017 are selected, i want to selected the max month end date of 2016 i.e 12/31/2016 and check between the duplicate table and get the count,similarly i want to selected the 2017 12/31/2016 and check the dates between the duplicate table and get the count. both these counts should be shown as a line chart . since these charts are not associated i am seeing only the toal counton 2 years
Please find the sample.
Thanks for the response,
but when ever i select any month ,i need to see the monthend value falls between the start and enddate of the duplicate table. when i use the above formula and make selections it should get the count from the duplicate table.