Have you tried a running-difference formula?
------------------------------
Jenifer Broughton
------------------------------
Original Message:
Sent: Fri August 23, 2019 12:28 PM
From: MONA KEDIA
Subject: Week to Week comparison in report
In the below table, I want A, B , C and D data to get refresh every week from flat excel file and W2W comparison with the previous week data. What will be the formula to do W2W comparison.I have appended the both the weeks file with adding the date column.
------------------------------
MONA KEDIA
------------------------------
------------------------------
MONA KEDIA
------------------------------
#CognosAnalyticswithWatson