Forum Discussion
Difference between previous week and this week data
Hello, I have data as follows Date Sales Oct 4 - 36 Oct 11 - 30 Oct 18 - 25 Oct 25 - 20 I need the difference between this week and previous week data i.e Oct 25 - Oct 18 20 ...
Hi ApurvaKhatri,
No one here is intested in your actual data. Dummy your dataset and then share the result of that dummy dataset. The dataset that you paste here should be such that can be easily copied into an Excel file.
Hello Ashish_Mathur
| Number | Balance | Date |
| 0 | 61625 | 10/20/2017 6:15 |
| 0 | 67219.92 | 10/15/2017 6:15 |
| 2.26 | 59320.41 | 10/10/2017 6:15 |
| 0.22 | 82904.55 | 10/25/2017 6:15 |
| 0 | 89217.92 | 10/18/2017 6:15 |
| 0 | 58800 | 10/19/2017 6:15 |
| 0 | 89868.48 | 10/20/2017 6:15 |
| -1 | 74000 | 10/15/2017 6:15 |
| 0 | 68400 | 10/20/2017 6:15 |
| 0 | 72450 | 10/2/2017 6:15 |
| 4 | 70300 | 10/11/2017 6:15 |
| 0 | 68400 | 10/12/2017 6:15 |
| 0 | 91383.16 | 10/18/2017 6:15 |
| 48 | 91575 | 10/14/2017 6:15 |
| 1 | 70775 | 10/22/2017 6:15 |
| -0.01 | 88788.74 | 10/14/2017 6:15 |
| -0.79 | 60823.19 | 10/8/2017 6:15 |
| 0 | 71225 | 10/13/2017 6:15 |
| 0 | 72150 | 10/11/2017 6:15 |
| 0 | 71250 | 10/21/2017 6:15 |
| 0 | 69837.5 | 10/10/2017 6:15 |
| 47.15 | 97570.8 | 10/12/2017 6:15 |
| 0 | 62400 | 10/25/2017 6:15 |
| 1 | 60450 | 10/26/2017 6:15 |
I am unable to attach the excel file.
Hi,
What is the use of the Number column? I thought you just want to add the Balance column on every Wednesday and then take the differrence over the previous week. Please show the actual result you are expecting based on the data that you pasted above.