Monthly comparison showing best and worst

[maxsugak]

Hi everyone, just need help again.

I have sellers and their sales.

I was asked to show only those sellers who were better this month then previous month.

And vice versa show those who were worse this month then previous.

I've tried to make set analysis like this:

sum({<month={$(=Max(Month))}>} Quantity*ProductCost)
- sum({<month={$(=Max(Month-1))}>} Quantity*ProductCost)

but got only zeros.

Thanks for your help.

Max

[pradosh_thakur]

in which object are you using this exactly? if you can describe a bit more.

Try this may be assuming you have dates properly defined and the expression is what you need

sum({<month={"$(=Max(Month))"}>} Quantity*ProductCost)
- sum({<month={"$(=Max(Month)-1)"}>} Quantity*ProductCost)

[maxsugak]

I have sales list for year 2013.
It states date of sale, seller, product ID and selled Quantity.
ProductCost is defined in different table.

[OmarBenSalem]

Simplest way : 

sellers who were better this month then previous month:

Create a bar chart:

as dimensions:

Month

Seller 

as a measure:

aggr(if(Sum(Value)>=above(sum(Value)),sum(Value),0),Seller,Month)

sellers who were worse this month then previous month:

Create a bar chart:

as dimensions:

Month

Seller 

as a measure:

aggr(if(Sum(Value)<above(sum(Value)),sum(Value),0),Seller,Month)

here's a result per analogy :