Percent Change of Sales Week Over Week

1

I have a table with the same item (column 1) over multiple weeks (column 2). Lets say the items types of food at my store (milk, break, eggs). In Column 3 I will populate the number of items sold every week. In Column 4 I want to see the percent change in the number of items sold in the prior week. I have been using the formula based on Row ID, is this correct?

(thisRow.[items sold])-(thisTable.Filter(RowId(thisRow+1)).[items sold])

2

I am stating by creating a new column to pull the prior values, but not coming to a solution
[This Table].[ Items sold].Filter([Row ID]<thisRow.[Row ID]).Last( )

3

Hi Morgan,

Welcome to the community!

There would be several ways of solving this, but the RowID doesn’t sound like the most robust solution. I would use a date instead.

Your idea to create a column to pull previous sales is good, but you need to sort it to make sure you get the right one.

Here you have a little demo. Feel free to go through the formulas and let me know if you have any question.

Hope this helps,

Pablo

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.