Previous Month Sales

[#1]

Hi,

I'm trying to query sales from 8 months ago. Using the following query, I'm able to sum the current month's sales using the following:

[Calendar Month Name] = {'$(=month(now(0)))'}

However I cannot use the above query to sum sales for a previous month. For instance if I try:

[Calendar Month Name] = {'$(=month(now(0)-8))'}

OR

[Calendar Month Name] = {'$(=month(now(0))-8)'}

Both return nothing. Does anyone have an idea what I'm missing? I've searched the forum and have yet to find a solution.

Any help is appreciated.

Matt

[jagan · Accepted solution]

Hi,

Try this

[Calendar Month Name] = {'$(=month(AddMonths(now(0), -8)))'}

Hope this helps you.

Regards,

Jagan.

[#3]

Thanks Jagan,

That works perfectly! One issue though. I'm using this with other selections that are overriding the expression. How would I change the following set to ignore current selections and pull the data I'm looking for 8 months ago:

I've tried using a 1 intstead of a $ sign expansion, but was unsuccessful.

Thanks again for the help.

Matt

[#4]

Nevermind, I was able to figure it out, had misplaced my 1, which needs to go at the beginning of the expression.

Best,

Matt