Hello All,
I am working on the analysis which needs some manual updates in the data. This is recurring process (10 days in a month).
I have a Report (Sales Trend) in which some customer sales amount is different from another report ( Monthly Sales, this report I used to reconcile my Sales Trend report), I check all customer Sales amount and match them with the Monthly Sales report manually. I would like to ask, Is that anyway I can replace the manually updated customer record? I mean, I pull out mismatch data in the spread excel file and update the Sales amount as needed, and then remove the data from the Sales trend report only for mismatch records, and update the reconciled data. so that every day I just need to replace reconciled data with Mismatch data
Thanks,
@Learner09 can you provide some sample data and expected result?