Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

undefined

Hello Friends, situation:  see below, image 1 displaying the relationship: image 2 display the table and pivot table: image 3 shows i selected the category ID from table categories..  i really do...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi Anonymous ,

     

    I seldom use Power Pivot but, based on experience, that is how it behaves. Adding an aggregation to  Value should fix that.

     

     

danextian's avatar
danextian
Super User
2 years ago

Hi Anonymous ,

 

I seldom use Power Pivot but, based on experience, that is how it behaves. Adding an aggregation to  Value should fix that.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    danextian you are right.. it only works with a value field input! This is a big lesson thank you !!!

    I thought I have issue with bugs or setup not correct. 

    Thank you! 

    Zoey