pivottable

Hi guys, I am really new to VBA so I am looking for a way to create a VBA code so that it can return results on a pivottable for me, within a certain date range, which will be determined by two cells. i.e A5 = start date A6= End date And these two would be used as references for the pivot...

Lets say i have these PovotTable fields. FieldRow, FieldData1 and FieldData2. I put FieldRow in the Row area of the PivotTable, and so data fields will be summarized for each item of FieldRow. I put FieldData1 and FieldData2 in the Data area, and set them to aggregate by Average. I would like...

Hi Friends, I have a User form with a comboBox caled "cmbpivotvalue" . When i press Submit/validate button "cmbValidate" in the userform , the values in this comboBox should go to the "VALUES" section on the PivotChartFields (please refer the screenshot) . Please help me to create code for...

If I double click Grand total on PivotTable I get all columns of data including those not on the PivotTable. Is there way to get the data only for dimensions that appear in the PivotTable only ? Thanks

Hello, Is there a way to set each new pivottables to classicview by default in Excel 2013 ? Thanks in advance.

Hey all. I've found where other people have had this error but those solutions haven't helped me solve this one. Long story short I built this for another employee about a year ago and my memory is fuzzy on some specifics. There's only one PivotTable on the sheet. I get the typical error...

Hello everyone, My name is Ryan and I am new to the forum. I am fairly new to learning excel. I am currently enrolled in a class at Northern Virginia community college to help to become more familiar on how to use excel. I was wondering if anyone could help me to understand how recommend...

Hi All, Im not really an expert with coding VBA and hence rely on recording Macros. I have one macro which i awlays run but for some reason today i keep getting an error message as per below. "Run time error 1004" - The PivotTable field name is not valid. To create a PivotTable report, you...

Hello, I have built a sales report dashboard which is to be updated monthly with around 2000 rows of input. The data I input has the following categories/columns: Date | Sales rep | Product | Quantity | Value | Product category | Brand. Sadly, the company's software does not export the...

I have 2 different pivot tables on different Excel sheets using different data sources. They both have a "Style" column that can be filtered. When I filter for style on one pivot table I want the other pivot table to automatically (or with a button) filter for those same selected styles. I am...

I have 2 different pivot tables on different Excel sheets using different data sources. They both have a "Style" column that can be filtered. When I filter for style on one pivot table I want the other pivot table to automatically (or with a button) filter for those same selected styles. I was...

Afternoon All, Before I begin, I know that you can't implement true RLS in excel - but due to pricing, Power BI is a non-starter. These excel models will also not be shared outside of my organisation. The solution I'm using is obtaining the windows username via VBA, pasting it into a cell/table...

I found some code from https://contexturesblog.com/archives/2012/01/03/change-all-pivot-tables-with-one-selection/ and I was wondering if anyone could help me alter it to my needs. The first bit of code in VBA from Microsoft Excel Objects is: <code style="margin: 0px; padding: 0px; border: 0px...

I am trying to calculate the average amount of days a request takes. In my raw data I have a formula which takes off the day when received, to the day which is completed. I also have a field which determines which quarter it falls in, and a field which business area it is in. I can get it...

Hi, I've tried in vain to work this out myself and cannot find a thread that seems to match my query, so here goes: I have a PivotTable that contains product codes and monthly sales, I then have a table to the right of that (no column gap) that contains various formulas. My questions is: is...

Hi all, Is there a macro i can use to add and remove pivot table data fields "values". When adding i would require it to be by average. I'm a bit of a VBA noobie so would be grateful for any help on this. Thank you in advance.

Thanks in advance to anyone who can assist and I will provide feedback on suggested solutions. For the code to make a Pivot Table, I'm getting the following error: "Run-time error '1004': "The PivotTable field name is not valid. To create a PivotTable report, you must use data that is...

Hi, I have a credit card bill that i export. I also have a lookup table. <tbody> taxi1234 100 #6070 taxi998 80 #6070 starbucks 9 #6620 tax1234 88 #6070 taxi #5555 66 #6070 </tbody> I want the table above to do a vlookup in the table below. Look for anything *taxi* and use...

Background: I have an issue with formatting on a PivotTable. The row labels are long so the text orientation is set at 60 degrees. Preserve formatting is selected in options. The spreadsheet is a template which is used to produce data for a number of processes. The issue: The behaviour of the...