Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Available items by supplier?

Hi - I have 2 data sources; one is a sales table that has sales by item. Another is the list of all items available (active list), regardless if they have been sold or not. I currently have slicers that allow me to see how many items are in the active list, and how many items are in the sales table as well as the crossover between. 

 

The issue is that as I change another one of my slicers, the number of active items by supplier doesn't update. It's an accurate value of the total number of active items but I can't figure out how to have it update by supplier. The 2 tables are currently linked by a many:one single way relationship. 

 

Any suggestions? Is there more information that I can provide? 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I was able to figure it out - I had to re-arrange the relationships between 3 tables and it fired right up.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I was able to figure it out - I had to re-arrange the relationships between 3 tables and it fired right up.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    Anonymous sorry not clear what you are looking for? Can you share sample data/screenshots to explain the issue? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Here is how the tables are linked:

       

       

      This is the card that I want to update when the "Vendor name" slicer is changed. "Vendor name" is a field in both the active item and sales tables, but they are currently linked by APN (item number).