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 don;t understand why my pivot table display all product for  category 1, same for category 2 and 3? can someone please help?

i tried with different data model, came back the same result.. .. 

thank you in advance.. Zoey

 

 

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.

     

     

4 Replies

  • 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      amustafa Thank you.. I did not know it only works with value field input. 

      thank you

      Zoey