Day on Day analysis for Current month & last day for past month

[Anonymous]

Hi Guys,

I want to implement Day on Day analysis for Current month & last day for past month.

For example

For Sep it will give all Date & for Jan- aug it will  monthend of respective month..Once Oct come it will on day of Oct & if we click on  Sep it will give only 31 instead of all days

On 3rd Oct will 1,2,3 oct & 30/09/2017 for sep.

I tried to do this .But may I missing something  ,not able to achieve this.Please find the sample file.

[sunny_talwar]

Hi Shweta, I don't think I am 100% sure of your requirement... so when it is Sept, you will see all the month of September and you will see the last day of the month for the rest of the months? What happens when you make a selection? Just see last day of the month for all the months?