How can I put 2 pivot tables within the same sheet on a workbook. One I have a pivot table in a workbook and try creating a new pivot table and adding it the sheet with the first workbook it won't allow me.
help please
Logan
I'm trying to pull a chunk of data out of a cell but in each cell the league of the data coming out is different. It would look like:
0000905
0001845
0000845
0032609
I want to get everything after the zeros where the real number starts but can't figure out how to do it since there will be...
https://docs.google.com/file/d/0B95chUdM8W1GNDZOMmFhY2V3TWM/edit?usp=sharing
I posted a link from google docs so that you good see the data. In the graph you can see the years broken down from 2000, 2001, 2002 ect and what I am trying to do is to be able to combine that data into one year on...
I'm at work doing this and it's not letting me upload. do you have any email address I could send you some screen shots of the data to see what I'm talking about and be able to post that on here for me because it's not letting me post those either. Our IT department pretty much has a lock down...
I'm trying to do a sum within a sum in a pivot table. For example I'm doing the sales by different customer groups over a 10 year period. I want to be able to look at those customers with sales as a whole but also by individual years or only summing say the last 3 years. Also is there a way to...