I have a data set with several regions and costs associated to them. One of the regions is "Global" and it appears on the row list in my pivot table. I need to allocate costs all from the "Global" region against the other regions according to known %'s. Is this possible?
See sample file attached.
Any help would be much appreciated!
Michal
grab.PNG
Bookmarks