Dec 20 2019 06:56 AM
Hello everyone
I am new in this community, and I have to file I would like to improve.
I take the data from different sources, and the final product it´s a pivot table, which shows per client and per product (in that order) the forecast and the actual sale.
My idea is to have an extra row after every change in product, and in that row show the difference in percentage between the forecast and the actual
Take into consideration that I don´t have the latest excel version
Attached a short version of the file, but I believe it is enough, since there is one tab for the “raw” data and the other with the pivot