Results 1 to 5 of 5

Thread: Relation error message in pivot table when established relation in powerpivot - help!

  1. #1

    Relation error message in pivot table when established relation in powerpivot - help!



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

    This might be a trivial question for you excel-ninjas but I can`t figure this out.

    I try something as simple as linking in powerpivot a sales table with Year, Month and Week columns with another media spend table with different Year, Month and Week columns but with different number of rows. There is no dates here in either of the tables so I can`t link directly with a date table (as I have downloaded from Azure). In order to link the two tables I have made a YearMonthWeek column (translated from Norwegian):

    =TEXT([@YEAR];"0000")&TEXT(MONTH("1"&[@MONTH]);"00")&TEXT([@WEEK];"00") - the results in this output: 20120312 etc. Fine! (another excel-ninja gave me this function).

    So far so good. I manage to link the tables in powerpivot (no error message) but the problem appears when I`m trying to create pivot tables from the two different tables. Then the error message: "Relation is neccesary" proofs that there is a link missing anyway. But I have established relation between the two tables...What have I missed here?

    I don`t know if I have managed to describe my problem but if anyone in this forum could help me out I would really appreciate that! Do I miss a magical function or what?

    PS! I tried to make a demo-file but it didn`t pass the limitations at this forum. But I will send the file on email if anyone will help me out.

    Ole

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,604
    Articles
    0
    Excel Version
    O365
    Post the workbook in one of the web share sites, or OneDrive, or DropBox, loads of options.

  3. #3
    Where/how can I find the web share sites, or OneDrive, or DropBox?
    Hopefully you forgive a rookie on this site:-)

    Ole

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,604
    Articles
    0
    Excel Version
    O365
    I use cjoint, http://www.cjoint.com/

  5. #5
    need help in this as well

Posting Permissions

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