Depends on the scenario, are you trying to BLEND or JOIN a many to many? Sometimes simply applying a min, max or average aggregation instead of sum solves your problem but that depends on what you're trying to visualize and how your relationship is defined.
Aaron is correct, and there are quite a few threads on this forum related to this topic (just google "avoid duplication tableau" or something similar). Here's one KB article to get you started:
Is your question specifically on how to accomplish it in Tableau or more broadly how to do it in any BI context?
Tableau has some great options:
- Data Blending is one of the most powerful features of Tableau for accomplishing what you have mentioned (as Aaron and Matthew pointed out).
- Table calculations can also be used to de-dup data resulting from many-to-many relationships.
- Multiple views can be placed on a dashboard and actions can be used to see the many-to-many relationships.
More broadly speaking, there are certainly approaches for dealing with this on the back-end prior to using a reporting tool. The approach would depend on the data and ultimate objective.
Yes i am talking more in context to BI approach but tableau has it own great architecture.
As i am new user to tableau and has some difficulty in this scenario and want to get some solution or understanding how i proceed with tableau to get proper presentable data without duplication in aggregation.
Thanks and Regards