3 Replies Latest reply: Oct 11, 2012 7:11 AM by borislav

Why oh why is this soooo difficult....Please can someone explain to me why this is not working:

=Sum({< [ Date] = {">=\$vLastYearDay"} >} [Cart quantity])

I am trying to force a chart to give me yearly sales/quantities on a rolling twelve month basis starting on the current date so I would have something like:

2005        2006          2007          2008

50,352     48.214       75,654        85,920

BUT the current year would be today() and today()-365

last year would be today()-365 and today()-730

Pleas can someone help

Kind Regards,

Miles

Hi,

Is it working when you write it like this:

Sum({< [ Date] = {">=\$(=vLastYearDay)"} >} [Cart quantity])

If you want to show sales on a rolling twelve month basis starting today, you may create Calculated Dimension in a straight table:

'Before '&year(Today(0))-2)))

Then just sum your Sales in the expression.

Hope this helps,

B.

Thank you so much!!! borislav,

The expression did not work, but that calculated dimension is a dream...i am now glueing my hair back in!!

Thanks again,

Miles