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.
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:
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.