Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Hi Lina,
Can you share sample data and expected result?
Thanks