+ Reply to Thread
Results 1 to 3 of 3

Percentage total calculation in data model vs. not in data model

  1. #1
    Registered User
    Join Date
    10-10-2020
    Location
    us
    MS-Off Ver
    365
    Posts
    3

    Percentage total calculation in data model vs. not in data model

    I created a pivot table and did not import it into the data model. Later I needed to recreate the pivot table with it in the data model due to multiple data sources added from queries. The total percentages column calculates correctly when using a calculated field while not in the data model but adds the percentages together when the calculated column is added in the data model. How do I fix this?

    No OLAP.png

    OLAP.png

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,492

    Re: Percentage total calculation in data model vs. not in data model

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,230

    Re: Percentage total calculation in data model vs. not in data model

    A calculated field in a regular pivot table is equivalent to a measure in the data model, not a calculated column.
    Rory

+ 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] Pivot Table Slicer Field names (Data model vs Non Data Model)
    By NewYears1978 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-02-2021, 10:52 AM
  2. choose a model from a list and get prices from that model
    By peterroq in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-29-2021, 08:58 AM
  3. Add this data to the Data Model addition needed to current pivot table code
    By SarahPintal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2017, 06:52 PM
  4. Replies: 0
    Last Post: 03-26-2015, 10:37 AM
  5. 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
  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

Tags for this Thread

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