Compare last week to current week

[#1]

Hi All.

I'm having a problem while trying to implement the following request:

let's say I have the following fields:

Store name

Number of sold Items

Week number.

I want to display in a straight table the 5 bottom stores that sold Items last week (count (Number of sold Items)>0 )

but on the current week which was selected they sold nothing or much less items.

Can someone please Advise?

thanks. 

[consenit · Accepted solution]

Hi there.

Have a look at the document attached.

Kind regards,

Ernesto.

[Anonymous]

Hello,

maybe you can use [Store name] as dimension and the following expression (if you want to display sum of number, otherwise you cab use count):

if(count({<WEEK={"$(=$(vWeek)-1)"}>}NUMBER)>0 and (count(NUMBER)=0 or IsNull(count(NUMBER))), sum({<WEEK={"$(=$(vWeek)-1)"}>}NUMBER))

In dimesion limit tab you can set how many stores display in the dimension

Hope this helps, Elena

[Anonymous]

Sorry, I forgot a detail:

vWeek= GetFieldSelections(WEEK) where WEEK is your Week number.

And NUMBER is your Number of sold Items.

[#5]

thanks you so much!

[#6]

Thank you!!!

[anbu1984]

To calculate difference current and last week, you can use Column(2) - Column(1)