Data based on month selection

[balaji_m]

Dear Experts,

Please help us on this below request

I have date  and count (records) for particular date.

when I select dec 2017 I will get one month date i.e 1st Dec 2017 to 31st Dec 2017 based on below screenshot.

My out put should show additional one bar with 1-Jan-2018 date and corresponding value.

it should show all the months based on use selected month.

i.e...if user selected June 2017.it should show 1-jun-2017 to 1-July-2017.

Regards,

Balaji

[MK_QSL]

Change my expression as below..

IF(GetSelectedCount(MonthYear),

SUM(

{<

Date = {">=$(=MonthStart(Max(Date)))<=$(=MonthStart(Max(Date),1))"},

MonthYear=

>}

Val),

SUM(Val))

[MK_QSL]

If you want to select more than one MonthYear then use below expression.

IF(GetSelectedCount(MonthYear),

SUM(

{<

Date = {">=$(=MonthStart(Min(Date)))<=$(=MonthStart(Max(Date),1))"},

MonthYear=

>}

Val),

SUM(Val))