data field

  1. T

    Hiding Power Pivot Data Fields VBA

    I'm trying to hide certain data fields (or cube fields in this situation) with VBA. Here is my current code: Dim pt As PivotTable, cf As CubeField Set pt = Sheets("RECAP").PivotTables("Major/SubCat Pivot") With pt .ManualUpdate = True ActiveSheet.PivotTables("Major/SubCat Pivot").CubeFields...
  2. S

    VBA: Adding and Removing Pivot Data Fields

    Hi All, I am new to VBA, and am looking at ways to have pivot columns show up, based on a data validation list - so that the user can select a location in a cell, and then the pivot table updates to show only the column related to that Location. The locations are set up as columns in the...
  3. S

    VBA - Add more than 1 pivot table data fields

    Hi, I am automating a pivot table and I want more than 1 data fields. For the row fields it accepts an array: pt.AddFields RowFields:=Array("GPProject", "Department",) But it won't accept that for the data fields, below is the code for a single field pt.AddDataField...
  4. A

    Sort on Excel Pivot table data field

    I know how to sort Excel Pivot table row and column fields, but I wonder - does anyone know if it is possible to sort on a data fiekl, without copying the pivot table and pasting special values elsewhere? I suspect isn't possible - but just in case . . . Best wishes Alison
  5. P

    How to use a formula in Getpivotdata data fields

    I am trying to use the getpivotdata function in excel. I can use it to simply drag data from a pivot table in another file quite easily as below: =GETPIVOTDATA("Temperature",'[20090109.xls]Sheet1'!$B4,"Date",DATE(2009,1,9),"Hour","00") I would like to be able to make this formula more...
  6. R

    Remove all datafields incl. calculated fields in pivot table

    I'm trying to write a macro that looks up the data fields in a pivot table, and if it finds any then removes them. It works fine when there's no calcualted fields present, but if there are calculated fields present then it bombs out. I think this is because calculated fields cannot be turned off...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...