I am working on a dashboard which uses multiple sheets. I am using sheet for filtering data in other sheets. But when I select a dimension in a source sheet the percentage value in other sheet does not get added up to the dimension value selected, instead it goes beyond 100%. Also I am using calculated field to display percentage. Can anyone help?