Forum Discussion
Adding a Slicer to Many to Many Table
Hi everyone, I have a campaign member table like this: Campaign ID Name Year Status Account ID XXXXX A 2017 New GGGGGG XXXXX B 2017 2 Years YYYYYY YYYYY A 2018 New GG...
Thanks Tim. I am still verifying numbers with my report, but I think I found a solution. I created a conc column (campaign ID & account ID) for both my campaign member table and transaction table. I also created a bridge table with unique conc from both tables. Then, I linked relationships based on conc, not campaign id. It works in my example table, but hoping this solves my issue. I appreciate your help.
Hi Anonymous ,
Has your problem been solved? If it is solved, you can mark the solved answer as a mark
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.