I have attached my file. In the file is a Pivot and the pivot's data file.
If you look at the pivot, I have Product 1, Product 2, Product 3, Product 4 and Unknown in the first column.
I would like a formula, to use in the data file, that re-distributes the Unknown values evenly - across the different Areas (i.e. LAC, Canada, Federal, etc) based on the following percentages.
Product 1 - 64%
Product 2 - 16%
Product 3 - 17%
Product 4 - 1%
For example Unknown for LAC is 1545 and Product 1 for LAC is 2502. 64% for 1545 is 988.8. I would then add the 988.8 to the 1545 for a total LAC of 2533.8
If this formula could be some kind of Macro that would be great as I will have to do this weekly.
But I am relatively a beginner and don't know too much about macros and nothing about VBA (but I'm willing to try).
Any help would be appreciated!
Start Free Trial
