Results 1 to 7 of 7

Thread: PowerPivot Relationship Trouble

  1. #1

    PowerPivot Relationship Trouble



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm having trouble getting started with relationships in PowerPivot. I've created a dimension table and a fact table and put those in the data model. I linked the many-to-one relationship, but when I create the Pivot table and drag in fields from the dimension and the fact table, the summed dollar values from the dimension table are always displayed as totals. I expect them to be filtered by the dimension attributes. Perhaps someone can point me to a simple example or perhaps someone is aware of a bug or common issue that I'm missing. If I could post attachments here I would love to share and get your thoughts on where I'm going wrong.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,652
    Articles
    0
    Excel Version
    O365
    The form accepts attachments, click the 'Go Advanced'button, and I think we would need to see the workbook. Mention if it is 2013 or 2010.

  3. #3
    This is for Excel 2013. I hadn't noticed the advanced button with the attachments option. Unfortunately, the upload isn't working for me yet...still trying

  4. #4

    Attachment

    Ok, here's the file I'm having trouble with. In the Pivot Table sheet, I have the pivot table on the left. To the right is the my desired output.
    Attached Files Attached Files

  5. #5
    Any ideas, Excel Gurus? I know you can help me figure this out.

  6. #6
    Excel 2013 Pro Plus
    I recommend this book, for the basics:
    Microsoft Excel 2013, Building Data Models with PowerPivot
    by Ferrari & Marco
    Here is your redone file:
    http://www.mediafire.com/view/kkbu8l...01_22_15a.xlsx

  7. #7
    Herbds7, thanks so much!! That's the piece I was missing. I didn't understand that I needed to pull the dollars value into the fact table with the related() function. That's exactly what I needed. You rock!!! Thanks also for the recommended reading.

Tags for this Thread

Posting Permissions

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