Limiting data using Only-function

[#1]

Hi,

I have sales data that I'm trying to limit in table/chart using Only-function in Expression.

Sum

({$<[YEAR]={$(=Only([YEAR])) }>} Sales)

Now I'm trying to limit the data also with month, but without any success. Is it possible to limit things using Only-function several times like this?

Sum

( if ([YEAR]= [YEAR]-1, {$<[MONTH]={$(=Only([AsOfMonth])) }>} Sales )

I know, this does not work. The idea here is to limit year to be last year and month should be selected.

Second question: I shoul also calculate last 12 months sales from same table. There is date, month, year etc available. What would be the best way to do that?

Here is the sample report.

[#2]

Hi again,

There are two issues:

No 1:

There is something wrong with 12 months sales. If I choose eg only one costcenter, the number won't change and numbers are wrong too. Look at the example file sent here May 12th

No 2:

How to calculate 4 weeks average on week level? There a sample of report here as well few message back.

Ville

[#3]

Thanks DV ,

i was looking for diffrence between $ and  {1} for many days your explantion helped me a lot !!

  Thanks Good !!!!

Regards,

  Anant