Month Over Month Sales

[Anonymous]

I've tried variations of all the formulas I've found on here for month over month, and so far none of it works.  I need to see sales month over month like this, MonthYear, that month's sales, then the previous month's sales in the 3rd column.  Please somebody help me.

[OmarBenSalem]

your first expression is :

sum(Sales)

add, in the 3rd column : above(sum(Sales)

and see what happens

[Anonymous]

3rd column as: !

peek(sum(Sales))

[OmarBenSalem]

Peek is a script function; you can't use in the front end; above will replace it in the front end.

Peek can be used for the same purpose as follow, but within the SCRIPT:

QlikView Peek Function

[Anonymous]

I'm just a user, not a developer.  I do not have access to the back end, so I can't create variables, either.  I will try the 1st option, though.

[Anonymous]

"Above" worked.  If I reverse the sort to show most recent month first, do I use "below"?

[Anonymous]

"Above" worked.  Trying "Below" for a reverse sort.

Jodi

[Anonymous]

Below only works so long as I have no filters.  I have an if/then saying if the month below was 0 or null, do this.  Let's say the changeover happened in January 2018.  As soon as I filter on just 2018, there is no below and January doesn't calculate correctly.  Please, I need a formula that will bring me sales data for the previous MonthYear in each line item.

Again , I cannot create variables.

[zebhashmi]

Sum({$<Date = {$(=addmonths(Date, -1))}>}Sales)

[Anonymous]

I’m sorry, it’s not working. This is the formula I adapted from your response:

sum({$}GROSS_ACTS_REACTS_UPGRADES)

I’m getting all zeros in that column.