I am working on an Activity Based Costing model, data sits in Analysis Services cubes. I have similar activities that sit across different cost centres (organisational levels). When I try and display just the activities for a group of cost centres, the same activity is repeated for each cost centre. My guess is Tableau is reading the activity ID code (which is unique) from AS hence each activity is displayed multiple times. Is there a way I can show these such that each activity name only appears once summing all activities with the same name across all cost centres.