Forum Discussion

zenisekd's avatar
zenisekd
Super User
5 years ago

Circular reference and filtering

Hi everyone,    Recently I run into a puzzle.    Our customer sells products, that can be sold as a single product or as an assembly of products (set).  When, upon request, I created ABC analysi...
Need Help
zenisekd's avatar
zenisekd
Super User
5 years ago

Hi Rico, 


I am sorry, but this is not the solution I was looking for. I need to have both tables on the page, so that primarly I could scroll through ABC table and see all the details about the products and if I wanted to, I could click on specific line of the table, which would filter TABLE 2 and gave me info about a) in which sets is the product used and b) what was the sale of these sets. 

With your solution, I have a slicer, which however doesn't meet the requirements since I need to see the details of TABLE 1. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi zenisekd 

Could you share a sample with me by your Onedrive for Business?

This will make it easier for me to understand your requirement.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.