Count of Current Month vs Previous Month

[#1]

Hi All,

I have the following data:

Code	Date(MM/DD/YYYY)
ABC	1/19/2014
DEF	2/15/2014
XYZ	2/20/2014
HIJ	3/25/2014
PQR	3/27/2014
RST	3/30/2014

I need to find the Count of Code for March v/s Feb.

I used the following variables:

vCurrentMonth =MonthName(Today())

vPreviousMonth = Date#((vCurrentMonth -1),'MMM-YYYY')

I am unable to find the count of Code for the above data.

[CELAMBARASAN]

Try this set of expression

Count({<DateField={">=$(=MonthStart(Today()))<=$(=Today())"}>} Code) for Current month count

Count({<DateField={">=$(=MonthStart(Today(), -1))<=$(=Date(Floor(MonthEnd(Today(), -1))))"}>} Code) for Previous month count.

[tresesco]

Try like:

vPreviousMonth = MonthName(AddMonths($(vCurrentMonth), -1))

[MK_QSL]

Please check enclosed file...

[#5]

Hi,

I did get my Current Month and Current Month -1 answer correct, however I would like to know can I get CurrenMonth and CurrentMonth-1 field as dimension.

As I want to develop a chart for this two dimensions only.

[tresesco]

Two ways:

• Calculate one additional column as PreMonth in the script.
• Synthetic dimension using ValueList() in the front end.

[MK_QSL]

Create a straight table with

Month as dimension and

Expressions as below...

For Current Month

Label

=Month(Today())

Expression =

COUNT({<Month = {'$(=Month(Today()))'}>}Code)

For Previous Month

Label

=SubField('$(MonthNames)',';',Month(Today())-1)

Expression

COUNT({<Month = {"$(=SubField('$(MonthNames)',';',Month(Today())-1))"}>}Code)

[#8 · Accepted solution]

Try using calculated dimension in pivot table like

=if(MIxMatch(MONTH(SALEDATE),month(today()),month(monthstart(today())-1)),MONTH(SALEDATE))

and the Expression = Count(CODE)

[jagan]

Hi Hitesh,

Please find attached file for solution.

Regards,

Jagan.