pivot data fields

Hello, I am trying to create a pivot table from data that I have collected from a group questionnaire, there is 40 questions. Each question has about 5 different answer options. Every time I go to create the table it adds all the answers up to give me a total of people that answer. I already...

I have a doucment with many sheets, one pivot table per sheet. I would like to use a macro to change their data sources all at once to the same data source. I found this code wich I would like to use as the data source..this ensures there are no extra empty cells (which causes my Value Field...

I am working on a pivot table in VBA. I have a working code for creating the pivot table and filling in the fields. What I would like to do now is to filter the data by dates. In the report filter, I am trying to select specific dates that precede a user inputted date. Say I have a list of the...

Okay - So long story short, I have a pivot table that gets its data from sql server using a data connection. Simple refresh and populate the data. One of the fields is being utilized as a filter for the pivot table. My problem is that on refresh today the filter values are missing 1. Did...

I am trying to produce a pivot table that will count a column that contains week numbers when specific reports were closed. However, as the cells within the column contain a formula it seems as if the pivot table will include those that are 'blank' i.e. the result of the IF statement is ""...

Hi, I have a PivotTable with a filter on it. When the user selects an option from the filter, the PivotTable will change in size, from a minimum of about 4 rows, to a possible 40 rows. I have a table directly below it which uses 'getpivot' formulas to perform a few simple calculations. I...

I have a macro that filters a pivot table, resorts, then copies data to another area for more calculations. I need to always move the "(blank)" elements of the first column of the pivot table ("A") to the bottom of the range once filtered. I know I can use...

:confused:<P>This may be a Noob question, but i am not too familiar with sorting data.</P>:( <P> </P> <P>I have and excel worksheet with 12 columns of data i want to sort the data based on the first column, and then based on the data in the second column, I want to sum the 3rd through 12th...

Having problems with VBA Code to do the following: 1. Check for Data Field "Report" 2. If Data Field "Report" Exist - Do nothing 3. Check for Data Field "Month" 4. If Data Field "Month" Exist - Remove or It may be simplier to remove all data fields and add the ones needed per DBA. Is...