Problem 1: I am trying to compare different sets of data against the total of the data. I have built a “bar-in-bar” chart and its working with the use of a parameter for the Business Units. Problem I am having is that our data is not clean so some business units need me to filter out a division here and there. When I do this it changes the total comparison number.
Problem 2: I would like to control what the total is based off of. I would like to set the total to be a Company Name, Business Groups or a Business Unit if possible.
Any help would be greatly appreciated. I think my top bar is some sort of parameter controls and the bottom total bar would be by filters but I have no idea.