Current and Previous month count total in same chart and waterfall chart

[saumyashah90]

Hi ,

I have data like,

Table1:

CGID	DATE	ID
16234	30/04/2016	1
16238	31/03/2016	2
123445	31/03/2016	3
423712	30/04/2016	4
213213	30/04/2016	3
34234	31/03/2016	4
5453254	30/04/2016

Table2:

CGID	DATE	Type	SubType
16234	30/04/2016	NC	a
16234	31/03/2016	DC	b
123445	30/04/2016	NC`	a
213213	31/03/2016	NC	d
5453254	30/04/2016	DC	e
5453254	31/03/2016	DC	d
213213	30/04/2016	DC	e
423712	31/03/2016	NC	b
423712	30/04/2016	NC	a

No i have key of CGID&DATE between both

I want waterfall chart based on SubType

Start month will  be count(CGID) for March

and all others will be count(CGID) for April.

In a chart i have DATE Type as  a dimension and expression i need countof CGID for current month and previous month.

And all this should filter with ID's.

and Current month (April) is selected.