-
Hi Everyone - I have a stumper that several other boards did not have an answwer for, and I hope that someone can help. I have to run several pivots to fill a crystal xcelsius excel input model - two of them count partner company names and user IDs by region and country via the index function. What I...
-
Hi, I would like to create a Pivot Table where I have say four rows all in column format. They are Broker, Portfolio, Port ID, Rate(decimal). The data is Amounts in dollars. You have many variations across these four fields but for illustration and more particular to address my problem here is an example...
-
As a general rule I store all my data in Access and analyse it using pivot tables. To get the data into excel, I tend to use OLEDB because i found the Access ODBC driver had too many syntax limitations. So to get at your data in Access: select Data\Import External Data\ Import data. Select 'Connect...
-
Whoops, my mistake. You cannot use dynamic ranges with MS Query. The usual workaround is to place each data range on a separate sheet and define range names like this; HoursWorked =Sheet1!$A:$E This assumes that column headings are in the first row, and there is nothing below the data. The range includes...
-
With most of my data stored in Databases, my first job when wanting to look at that data is how do I get it into a pivot. I run a mail order company, so everything is looked at in 500 different ways to spot that small trend that could make a huge difference to catalogue response. When training (I have...
-
Most pivot tables in Excel are built using a simple Excel list as the data source. This is the default in the pivot table wizard. We can also base pivot tables on external data. Typically the external data is taken from a database or text file, however there are also advantages to working with external...
-
Omar Certainly I suspect you will need to have multiple cells, which would not be ideal. I would suggest using a Pivot Table rather than the 'flat data' and then you could set up the employee IDs as a page field for example and filter out some. For help with Pivot Tables, there is some info on...
-
Frequently I found that the desired x-y orientation in a pivot chart requires to switch the row and column fields in the associated pivot table. So I wrote a little procedure that allows to do just that with ease. I've only tested it so far with relativly simple pivot tables. It seems to work fine...
-
I'll start the PivotTable forum off with a cheap trick. Did you know you can use a pivot table as the source for a histogram? First, you need to create a pivot table where the data values are plotted in the Row area (not the Data area). Notice that the SalesAmount field is placed in the Row Labels...
-
Welcome to the Pivot Tables Forum You should post any questions on the greatly under used feature in excel that is Pivot Tables. This great feature allows you to group and summarise data from inside Excel or virtually any external data source. This will stop you producing that report every Monday morning...