+ Reply to Thread
Results 1 to 6 of 6

GetPivotData but with data model

  1. #1
    Registered User
    Join Date
    02-03-2011
    Location
    Bulgaria, Europe
    MS-Off Ver
    2007, 2013
    Posts
    59

    GetPivotData but with data model

    Hello all,
    I try to get each value for total of field in pivot table (PT)
    but the PT is with data model (excel version 2013)

    Get pivot datae.JPG

    I use:
    Please Login or Register  to view this content.
    but do not working

    Is it possible to exist other syntax for PT with data models?!?!?

    Thank you for all who answered.
    Bye
    Last edited by rodich; 08-04-2016 at 03:38 AM.
    ?If you have an apple and I have an apple and we exchange these apples then you and I will still each have one apple. But if you have an idea and I have an idea and we exchange these ideas, then each of us will have two ideas.?

    George Bernard Shaw

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: GetPivotData but with data model

    try:
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    02-03-2011
    Location
    Bulgaria, Europe
    MS-Off Ver
    2007, 2013
    Posts
    59

    Re: GetPivotData but with data model

    thank you for the message and for the idea!!
    In really is more complex:

    Please Login or Register  to view this content.

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: GetPivotData but with data model

    So you are trying to convert that formula into a VBA statement?
    Try:
    Please Login or Register  to view this content.
    Where PT is your pivottable object.

  5. #5
    Registered User
    Join Date
    02-03-2011
    Location
    Bulgaria, Europe
    MS-Off Ver
    2007, 2013
    Posts
    59

    Re: GetPivotData but with data model

    I have success after your comments
    Many thanks for the help!!!!!!!!!!!!!!!!

  6. #6
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: GetPivotData but with data model

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can 'Add Reputation' to whose who have helped you. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] GETPIVOTDATA Problem (Data Model)
    By troilii in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 03-23-2021, 01:01 AM
  2. Excel Model Not Working - GETPIVOTDATA and Dates Not Right
    By wesleyjf91 in forum Excel General
    Replies: 0
    Last Post: 07-14-2016, 01:10 PM
  3. Replies: 0
    Last Post: 03-26-2015, 10:37 AM
  4. How to make a time period a variable for this model? (automating the model)
    By pigment01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2015, 12:47 PM
  5. [SOLVED] GETPIVOTDATA – How to force getpivotdata to accept missing data
    By scottc_00 in forum Excel Formulas & Functions
    Replies: 39
    Last Post: 02-11-2015, 03:23 PM
  6. VBA Model : Two Stage Gordon Model
    By elaph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2014, 11:37 AM
  7. Create a model that will generate a column of numbers based on model parameters
    By tncanoeguy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 05:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1