# Percent Change of Sales Week Over Week

**URL:** <https://connect.superhuman.com/t/percent-change-of-sales-week-over-week/52883>\
**Category:** Ask the Community\
**Created:** [December 9, 2024, 10:31pm UTC](https://connect.superhuman.com/t/percent-change-of-sales-week-over-week/52883 "2024-12-09T22:31:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Morgan\_Eliason](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/morgan_eliason/32/44927_2.png) [@Morgan\_Eliason](https://connect.superhuman.com/u/Morgan_Eliason)\
**Post date:** [December 9, 2024, 10:31pm UTC](https://connect.superhuman.com/t/percent-change-of-sales-week-over-week/52883/1 "2024-12-09T22:31:15Z")

</div>

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])

---

<div class="post-metadata">

**Author:** ![Morgan\_Eliason](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/morgan_eliason/32/44927_2.png) [@Morgan\_Eliason](https://connect.superhuman.com/u/Morgan_Eliason)\
**Post date:** [December 9, 2024, 10:46pm UTC](https://connect.superhuman.com/t/percent-change-of-sales-week-over-week/52883/2 "2024-12-09T22:46:27Z")

</div>

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( )

---

<div class="post-metadata">

**Author:** ![Pablo\_DV](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pablo_dv/32/49028_2.png) [@Pablo\_DV](https://connect.superhuman.com/u/Pablo_DV)\
**Post date:** [December 9, 2024, 11:18pm UTC](https://connect.superhuman.com/t/percent-change-of-sales-week-over-week/52883/3 "2024-12-09T23:18:56Z")

</div>

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.

https://coda.io/embed/lore4NNI1u?viewMode=embedplay#_tu6qp/r29&view=full

Hope this helps,

Pablo

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [March 9, 2025, 11:18pm UTC](https://connect.superhuman.com/t/percent-change-of-sales-week-over-week/52883/4 "2025-03-09T23:18:56Z")

</div>

Closed on March 9, 2025, 11:18pm UTC

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