Search results

no hints on this one? :

:O Thank you very much!

Sorry, could not figure out how to do it. I must mention that I am using excel 2003. In the filter list on a pivot table I do not have any more options than to check/uncheck the boxes referring to each item or to all of them.

That would still be an aproximated value, and not the real one. For example, if you put "10" in the FC, you may reflect an average of the following values: 3; 5; 7; 10; 13; 15; 17 Then, if your initial stock is 25, you can REALLY cover 28 days (3+5+7+10) while for an average of 10 per week...

Hi, Is there any way to re-arrange the order of the items in one specific filter in a Pivot Table? It seems that excel sorts it "in order of appearence", but could it be done in alphabetical order, for example? Reason: I'm tired of doing millions of Move Down/Move Up/Move to end... Thanks

Wow, that was fast! Thanks a lot. Nevertheless the coverage you calculate is based on an average FC, and that I can do. What I would need is a way to calculate it with real FC (data in C4:H4) and not averages. Do you know a way? Thanks

Hi, I am doing production planning and there is an issue that has haunted me for a while. When you have a stock figure and based on a weekly sales forecast figure (that may change from week to week), how do you calc how many weeks you can cover with that initial stock? Manually: Stock=100...