Forum Discussion

mbnumb6's avatar
mbnumb6
Regular Visitor
3 years ago
Solved

Help with filtering on two different columns for drillthroughs

Hi everyone,

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?

2 Replies