I need help with filtering for drillthrough purposes.
Ok originally I had a column called "Annual Obectives". That column orginally had multiple values in a cell. So when I was trying to create a pie chart based off that column, it wasn't working correctly because there was more then one value in a cell. To solve that problem I simply split the column into two as seen in the first screenshot.
Now I am trying to create a pie graph that captures both column's values. I also don't want every single value from both columns to be displayed in this pie graph. That means I'd like to have this pie graph filtered down to a select few values, examples like only show "Reduce Agent Calls, Improve Ease of Use..." and NOT have "System Maintenace".
I am running into two problems:
First as seen in the second screenshot
As seen in the screenshot above, the problem I am running into is when trying to filter one column, it affects the second one. Am I apporaching this correctly? Do I need to make a measure to solve this?