pivot 2010

Hi I am using slicer to show my pivot table data. However, I want to restrict the number of items selected in a particular slicer to 1 at a time. Can someone help me out. Data detail: Raw data looks like: Location>>People>>Designation>>Score Slicer is on location and I want to restrict the...

Ok so I am sure this simple, but it have me foxed. I have a pivot table, which looks like below: <tbody> Hub Role B/F/A Sum of 23-2015 Sum of 24-2015 Sum of 25-2015 Longbridge Civils Site Supr Budget 0.20 0.25 0.30 Forecast 0.20 0.25 0.30 Actuals 0.10 0.25 0.35 </tbody> This is...

Hello, I am trying to extract text from multiple cells that exist in a pivot table and return the concatenated text to one single cell in a separate workbook. Below are more details on what I am talking about. In workbook one, there are data in this format in a pivot table: Column A) Line...

Hey Guys, I've got the following issue: Using W7 and Excel 2010, I have a data sheet containing ca. 34.000 rows. I currently have a column which calculates the difference in time between two time entries through the use of a formula. The formula i'm currently using is...

I have a workbook that gets updated daily and for each day we create a new sheet. I have a pivot table that summarizes column D (item#) and column C (quantity). when I copy the sheet the pivot table stays linked to the data on the original sheet and not the new sheet. I must be missing something...

Hello, I am doing comparison of data between 2 years and I would like to have the colums of 2014 colored slightly different than the 2015 column. Can this be done automatically? Any help is appreciated

Could someone help me out with applying a conditional formatting to a pivot table in Excel 2010? Example: I would like to highlight the totals for Sales Regions that did not meet their sales quota for a given month. Sales regions are drilable to show salesman names and their sales for past 12...

Hi, I have performed a vlookup to bring the in the figures I require... The only problem is that there's many duplicates (but I can't remove the duplicates as the data is used for other function. I would like the vlookup to do the following: Column A is how the data lookups now but I would...

Hello, I am working on creating a report using a pivot and I can't seem to get the subtotal to calculate properly. I have broken out each departments totals by its group and I used a calculated item to create the combined field ( group a + group b + group c + group d). I need to have to...

Hi All Only used pivot tables for very basic things and never had an issue, and its been a while since I created one myself (about 2005!). I am using Excel 2010. I've tried google help and swapped the fields all over the four possible options but it wont do what I want it to do. So I am coming...

Hello Everybody, I am stuck at a problem that I been trying to solve for almost a day now. My problem is to remove a specific calculated field from the pivot table. I know we cannot hide the field and I do not want it gone forever as I need it somewhere else so I was surfing through different...

Hi, I have a cube backed by an SSAS database, and when I have fields in the Report Filter section, the "Include new items in manual filter" option is greyed out. Does anybody know why this is and if there is a way to get it to work? When they are in the Row Filter or Column Filter section, the...

Hi I have a pivot table with various columns which show a cost for each category (ie each column).</SPAN> I want to add in a calculated field in the pivot table to show the percentage of each column as the total of the row.</SPAN> I know this is easily done in the settings by saying show sum...

Hi there, I ran into a strange problem today. I received an excel file today and the underlying data is in table format. When i select the table and pivot it, there are 5 additional fields in the pivot and there are absolutely no hidden columns. For example, the table looks like Fruit Price...

Hi All, I am an excel newbie, please help, I created a pivot table, and inserted few new columns next to pivot and put in some comments on each row next to pivot table. The root cause of my problem is that those edits on each row outside pivot table is not linked to the row within the pivot...

Excel 2010 Windows 2007 I have checked all other posts with the same issue and cannot find and example that matches mine. I am creating a pivot table in VBA. I am getting the error message: Runtime error 1004-Unable to get the Pivot Tables property I have checked that the pivot table name is...

Hi all, I have a pivot table called "PivotTable1" on a sheet called "DataRequestPt". What I have been doing is applying various filters on this Pivot Table and then double clicking on the "CRN" field, which then spits out a data set to a sheet. Is there a way that the out-put be placed on a...

Hi All Hope your all well, I need some help in creating a pivot table for the data I have attached. I have tried everything from normalising it and using all possible pivots available with the informaiton if i create one but it is not being created. The problem I am facing is that the values...

Hi I have a pivot table report that uses a dynamic range as its source, the data is continually growing with new data sets added each day into the data table. To update the pivot I have added a Macro button which refreshes the pivot table, however as new dates are added each day the Value...

Hi this is my first post so if I'm doing this wrong I apologize. I have an issue with pivot tables (I'm not very good yet). I have an oracle database connection with the excel and as it pulls the data in, I have the pivot table breaking it down into each week. I need to be able to pull specific...