getpivot

  1. N

    Creating a GETPIVOTDATA formula that retrieves dyanmic "items" (as in the syntax [field, item] as defined by a cell reference

    Hi All, I am attempting to create a GETPIVOTDATA formula that retrieves dynamic "items" (as in the syntax [field, item] as defined by a cell reference. I have written the following formula: =GETPIVOTDATA("CS Hours", [reference to pivot table in another workbook], "Field Name 1",A2, "Field...
  2. A

    Use getpivot to reference row data

    Hello, I have the following getpivot formula. I can get it to correctly reference the right column headings (A5 and A6), but when I try to get it to cell reference one of the rows in the pivot (year) i get a cell reference error. Is it possible to cell reference row data in a getpivot formula...
  3. S

    Regional settings causing formulas not to work

    Hi everybody, Recently I have noticed that there are problems in my formulas related to the regional settings of my operating system. I am working with English (US) format but my colleagues are working with German(Germany) format. The difference between German and English is that "," and "."...
  4. P

    Calculating Experience / Learning Curve Series

    Hello to all, I hope someone has seen this problem before and my explanation is clear. BACKGROUND: I'm trying to have Excel calculate periodic (in this case monthly) sums for sales people hired at different periods where each one will be productive according to a calculated experience...
  5. A

    Summing Mulitple values from variant pivots

    Hello, I am trying to add data from 3 different pivot tables for a certain value set, generally my equation is working but I am running into a problem with one of the categories as it is null in one of the three sets I am addding from - causing the entire thing to kick back blank. Here is my...

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