I am not sure if I am doing something wrong, or if there is a system limitation? I will do my best to explain what I am trying to accomplish.
I wish to create a pie chart that will show the four data curves selected in the image below. I want them to be represented as a percentage of the total hours.
I also need to be able to filter this chart by description as shown below. This way I only display one type of tool at a time. Then I need the user to be able to filter the data again by tool serial number. as shown below. Is this possible? When I try to do this it only allows for one data curve in the Y axis. Please advise if I have made an error, or if there is a work around.