MTD and PMTD

Anonymous — Thu, 12 Jul 2018 14:12:49 GMT

How do you get to show all the Months if you are doing a comparison of CMTD with PMTD

using these Expression because now it only calculate for the Current and Previous monthly only e.g

it calculates for July and June but i want it to do for all these other months for instance January, Feb,Mar,May,June,July

FOR CURRENT MONTH:

=Count({<YEAR={'$(MaxYear)'},MONTH = {'$(MaxMonth)'}>} DISTINCT(PORT_ICCID))

PREVIOUS MONTH:

=Count({<YEAR={'$(MaxYear)'},MONTH = {'$(vPriorMonth)'}>} DISTINCT(PORT_ICCID))

Re: MTD and PMTD

Chanty4u — Thu, 12 Jul 2018 17:25:46 GMT

Anonymous — Thu, 12 Jul 2018 17:50:02 GMT

Hi Lina,

Can you share sample data and expected result?

Thanks