Thread: Need help setting up Pivots with data already entered

I have a lot of data that I need combined in pivots to compare. It's difficult to explain without showing you the files. I had help from someone here (I wish I could find them) who designed a table with prices, so when I enter the data, the price automatically shows in the column. I need to combine a years worth of data (I enter data for each month or a two month period) so I can analyze different prices. For example: Last year I had set prices for 17 different items. At the end of last year, I did "X" amount of items 1,2,3... Let's say item #5 was $40.00 and item 13 was $100. I first need to combine all the data in pivots and then I need a table where I can play around the figures to see what I could have made with the different prices. I'm sorry if I'm not explaining properly.

I also need help in formatting data for print. Someone set up a template from which I do all my work on. I need help in setting up where the pages automatically print with pivots of the data and a cover sheet that shows all the data from the main sheet. As it is now, it's just one long data sheet. I can send you my data and then a sample of how the last one was formatted. You will understand completely.

I'd rather not post the data online here, but I can email you everything.

Thank you!

Marty

Hi,
I've added an attachment with the figures changed, but kept all formulas.

The INPUT sheet tab is where I enter all my data. It has a table at the top right with all the figures.

The next tab is the PIVOT, which I don't know how to create.

The next tab is SUMMARY BY ITEM

The next tab is FINAL FORMAT, which I need to do for my current input data, so I can print it.

The final tab is the SUMMARY.

Can you help me set this up on my own? All I have is the INPUT DATA and nothing else.

Now that you can see the formatting, I do this every month or every 2 months. I need to take an entire years data and put it together. My only concern (or, what I only need) is adding up all of items 1-17 in separate rows with the total for the year multiplied by the price in the table.

It would great in a Pivot ot I can just create a simple 17 line spreadsheet with the items and price. I want to be able to play around with the figures to see a grand total. EX: Let's say last year I did $100,000 total. $50,000 for item 5, $50,000 for item 6, etc. If I can change the price of item 5, 6.. I will be able to forecast what I will make the next year.

Marty