Forum Discussion
ApurvaKhatri
Helper III
Helper IIIDifference 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 ...
Ashish_Mathur
Super User
Super UserHi 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.
ApurvaKhatriHelper III
Helper IIIHello 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.