-
Hi Roger, Thank you for responding. The pivot tables were created in Excel 2010. The challenge that I have, is that we have about 20 pivot tables that we are working with. He has provided me with a copy of the file that it needs to refer to, via dropbox, but the filepath of dropbox, makes use of my computer...
-
I create an Excel 2003 file with three different pivots from different sources. The file thinks of them as caches 1, 2, and 3. Then, someone uses the file in the new version of Excel, and then it thinks of them as 3, 2, and 1. So my macro that is supposed to do stuff to the pivot that uses cache 1 doesn't...
-
Hi, I create pivot tables for my work where I am plotting, on a per client basis (each line is a client): revenue, comission, etc. I organize by office. To make it easier for the offices to view the data, I use to show filter pages function to turn each offices list of clients into its own tab/worksheet...
-
Problem solved! Problem due to the fact that I was dealing with an OLAP data cube. Apparently, there are some limitations when dealing with an OLAP data source and the disabling of the show pages option is one of them. Inserting a calculate field /item is also disabled when the datasource is an OLAP...
-
Hello all! I have been looking at Excel help websites all day and I stumbled upon this site and decided to join because it seemed the most promising. Hopefully I will be able to give advice once in a while instead of always having to ask for it! I have a report where I have multiple subtotals and I would...
-
Thanks for your reply. However, your suggestion is relevant to Excel 2000/2003 and I am using 2010. The pivot table is connected to an external data source, which I am able to refresh. I suspect there is something in the table structure of the data source that is preventing this functionality as I am...
-
Below is a picture of my pivot table. To the right of the report filter is some data that comes from a source external to the pivot table data. I am trying to conditional format the "% Gr Var to Plan" column based on the data outside of the pivot table. I need to be able to figure out the service...
-
Dear ALL, I'm a newbie in Pivotable. For my study, I need to pick up the similar variables in specific stations in a very long timeseries of meteorological database. This work might be repeatly thousand times if I dont know how to create a general pivotable for these thousand sheets. I'm using...
-
I have a pivot table with abour 20,000 rowa. The field I need to use in the page filter has about 1300 possible values in random order. When I attempt to use the filter I notice isentical values in the drop down list. Why? and If I select any occurance of will the apply to all 20k records?
-
Hello, I have created a pivot chart that has the ROM for several campaigns and their attributes (creative, offer, location, etc..). The report filter I have set can filter on a date period or campaign type (online, print...). What I'd like to do it to create a series of pie charts to show the ROM...