1
  • Year over year pivot table

    Similar to your example except I want to show monthly columns with two separate years as rows in the pivot table below each customer, then insert an additional row between each customer for the % change like this                 Jan     Feb     Mar Smith & Co 2013        ...

    TonyX105 pointsBadges:
  • Setting a slicer in a pivot table

    I need to set a slicer in a pivot table by using VBA so that I can limit a number of filters the user choose. I mean if the user choose, for example, more than tree options in a slicer a warning message box pop up on the screen. This slicer I am talking about is based only in one field on the table.

    bosswt5 pointsBadges:
  • Pivot table Year over Year % increase

    I have created a pivot table. I have a list of years across the top row and the expense amounts under each column. I would like to do a year on year comparison to the previous column. Example 2013-2014        2014-2015         % Diff $354,378,067    $329,570,055       ?? I...

    bekgrealy5 pointsBadges:
  • How to get rid of blank areas

    I have a database that contains path diagnoses (rows) and stains (columns) used to determine diagnoses. Therefore for any single entry there may be multiple empty columns. When I make a pivot table I want to be able to show only columns with data in them.

    mensamedic5 pointsBadges:
  • Counts by time and date with

    I am trying to count logins by hour, by month, etc., in SQL Server 2008. To do this, I believe I need to create two PIVOTs or an UNPIVOT and then PIVOT? However, I can't seem to make it work. SELECT loginid ,DATEPART(MONTH,logtime) Month , DATEPART(HOUR, logtime) Hour FROM somelog (nolock) ) temp...

    ITKE346,360 pointsBadges:
  • Can a Pivot table be created in Oracle 10g?

    I am running a stored procedure on ORACLE 10g that truncates and repopulates a table (tbl_A) that contains 2 columns; a list of unique codes and monetary amounts. The number of codes may vary weekly. I would like to create a second table(tbl_B) that contains a column for each of the names being...

    CAJ5 pointsBadges:
  • Pivot Table Error Field Message

    I have a pivot table in my spreadsheet that is linked to an access database. When clicking on the refresh data button at the top toolbar to refresh the data in my spreadsheet from the new data hitting the access database, I receive an error message stating "The Pivot Table field name is not valid....

    Buckeyes0810 pointsBadges:
  • Pivot table automatic update in Excel 2010

    How to make my pivot table automaticly updated if I edit, delete, append the source data?

    Eogy60 pointsBadges:
  • Unable to Refresh Pivot Table if Datasheet in Excel 2007 is not open.

    I have several Pivot Tables linked to several like spreadsheets, respectively.  When I refresh a Pivot, I get an error that excel is unable to open the file (that the table is linked to). If the file is open, I can refresh.  My problem is each spread sheets contain huge amounts of data. Is there...

    Skb195510 pointsBadges:
  • Convert pivot table to normal excel sheet

    Hi, I have a pivot table and I want to convert this to a normal excel sheet. Theer are 3 records in the pivot table and now I want these 3 records as 3 column heads in the excel sheet. As a example there is project name, user name and description as records in the pivot table and now I want...

    EEEC20 pointsBadges:
  • Access 2003 – command button to show query in pivot format

    I have a form with a comman button.  I want the user to be brought to a query when they press the button.  The query is built in a pivot table format, but when accessed by the command button, it appears as a datatable instead.  What am I doing wrong?

    Smbecker5 pointsBadges:
  • Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables?

    Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables? This would likely be done via a web browser interface such as Joomlah.

    Restart15 pointsBadges:
  • Excel Pivot Table

    Sir I Using Excel Pivot Table I Create Calculated Filed Formula is If(((total Debit-total Credit)>0),(Total Debit-Total Credit),0) This Formula very perfect use But Pivot Table Grand Total show the zero (0) How Grand total sum run please tell me

    Sankar12345 pointsBadges:
  • Pivot Table Dimensions (Not all are showing in the drop down)

    I have created a Pivot Table with 5 different columns in the Page area.  Not all of the values in the raw data are appearing in the dropdowns.  I need to see all of the dropdowns for each of the 5 different columns.  Why is this only showing a partial dataset?

    Jzgraham20 pointsBadges:
  • Raw Data not in Pivot

    I have a large pivot table looking to a raw data worksheet. All the data in raw data is not showing in the pivot table.

    Ttucker10 pointsBadges:
  • Excel 2002 Copy GetPivotDATA function

    I have a number of different items that I need to extract from a pivot table. Can I copy the GETPIVOTDATA function? it seems to get stuck and return only the value from the first cell

    Steve74745 pointsBadges:
  • Pivot table error when sourcing data from Access

    Pivot table error when sourcing data from Access reads: Invalid bracketing of name 'mdb.'.

    LittleKro5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following