ryanchild292
New Member
Hello all you Excel Wizards and Witches,
So just like the title suggests, I'd like to use a pivot table as an order form. I've found that you can add data to a pivot table and have it saved. HUGE H/T to jeffreyweir for getting me this far. http://forum.chandoo.org/threads/data-entry-and-pivot-table.19443/
However, jeffreyweir's solution doesn't allow the data entered into the pivot table to be calculable. I'd like to enter the number of items we want to order and then have the pivot table calculate the total cost for that number of items (calculated field) and show a grand total at the bottom.
I've heard a rumor that the What If Analysis in 2010 could work, but unfortunately my employer only has 2007.
Any ideas on how to get this done? Out of the box thinking highly encouraged
So just like the title suggests, I'd like to use a pivot table as an order form. I've found that you can add data to a pivot table and have it saved. HUGE H/T to jeffreyweir for getting me this far. http://forum.chandoo.org/threads/data-entry-and-pivot-table.19443/
However, jeffreyweir's solution doesn't allow the data entered into the pivot table to be calculable. I'd like to enter the number of items we want to order and then have the pivot table calculate the total cost for that number of items (calculated field) and show a grand total at the bottom.
I've heard a rumor that the What If Analysis in 2010 could work, but unfortunately my employer only has 2007.
Any ideas on how to get this done? Out of the box thinking highly encouraged