pivottable

I have a PivotTable that shows expenses across departments. Each department has a set budget for the entire year. In addition to the grand total that shows how much each department has spent, I would like a column that shows how much of their budget is remaining. For example, the DA department...

Hey Everyone, I am trying to attach a slicer to 2 Pivot Tables based on different data sources. I am following the method as shown in this Youtube video https://youtu.be/p9VD0rsC_bk . I am using it as a guide for my own excel spreadsheet. For my own spreadsheet, I have ticked the box where it...

I have a PT that is created from a Power Pivot table and I want to loop through each item in the 1 column of the PT. I thought the following would workSet ptField = ptPivotTableList.PivotFields("Proper Name")but I am getting a 1004 error, Unable to get the PivotFields property of the PivotTable...

This is the code I'm using:Sub a_Recalc_Pivot_Table() ' Macro to recalculate Pivot Table. ' 2/7/12 Modified. WML ' ' 7/29/19 Copied from "Offfice Development Center". WML Call Initialize_Globals Data.Activate 'Determine the data range you want to pivot...

Hi All, I am receiving this message "A PivotTable Report cannot overlap another PivotTable Report", in a workbook of about 15 sheets or so. Usually when I have this error, I can identify where it is coming from by looking for overlapping pivot tables. I seem to have maybe identified the sheet...

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...