pivot items

Hello, I'm trying to automatically set the current year and next year in a pivot table using VBA. This is what I have currently Dim CurrentYear as Variant Dim NextYear as Variant CurrentYear = Year(Now()) NextYear = Year (Now())+1 With ActiveSheet.PivotTables("PivotTable1").PivotFields("YR")...

Hello Guys! I am working on a dashboard with a pivot table and I am trying to make it as automatic as possible. To do so, I would like to be able to activate different pivot fields (data, which corresponds to a specific week). The weeks' data are put into different columns. e.g. If I want to...

Hi all, I'm stuck on this issue and cannot figure out what it is I am doing wrong. I'm in the process of writing a macro to loop through visible fields in a pivot table, find the items in those fields that are filtered, and then apply those filters to the source data table. The particular...

Hello all, I am trying to have a pivot table that sorts the columns in a particular order. The issue is that if i use pivotitems.position = X, then I have to have a separate hidden function that tests to see if all the choices are there and if not then sort this way, and....well, I have 7...

Hi, I was wondering how can I group pivot items based on the name ?, e.g. I want to group all the pivot items that are not named US or CA or BR , I did a little research on the forum and I found a code that I can adapt but is not very elegant , so I'm wondering if you guys have a better...

Hi All, I have pivotitems in the rows field. And i wanted to sort all the pivot items in the ascending order. But the pivot items doesnot fall under any data type. So i developed code to sort the pivot items based on position property existing in pivotitem. It is working perfectly fine Excel...