Calculated Dimension based in Another Dimension

[#1]

Hello

I want to make a pivot chart that show me the sales of each store, but only I want to view the stores that have more than $ 800 in the last week based on today  (no matter the filters I use on dates).

I try to make the next calculated dimension but the system give me an error:

=If(Sum({<FECHA = {">=$(=WeekStart(Date(Today()-7))) <=$(=WeekEnd(Date(Today()-7)))"}>} TOT_COMISION_COMPARTIDA) > 800, TOT_COMISION_COMPARTIDA)

Somebody have a better idea

Best Regards

[sinanozdemir]

Try to put it in an Aggr() function.

Hope this helps

[#3]

Where I need to put it??

[sinanozdemir]

=If(Aggr(your function(), Dimension), Dimension).

[#5]

It not send me an error, but not display me the stores, only leave in blank the dimension

[sunny_talwar]

Try this may be:

=If(Aggr(Sum({<FECHA = {">=$(=WeekStart(Date(Today()-7))) <=$(=WeekEnd(Date(Today()-7)))"}>} TOT_COMISION_COMPARTIDA), SomeSortofStoreID) > 800, TOT_COMISION_COMPARTIDA)

[#7]

Nop is not working

[sinanozdemir]

Can you post a sample dataset if it is not confidential?

Thanks

[MarcoWedel · Accepted solution]

Hi,

one solution could be:

hope this helps

regards

Marco