Ignore the dimension, but uses it value in a new lookup?
I am recreating a report from another system in Qlik Sense. This report is a simple table of values for users where they are the event agent. So my dimension on the table is EventAgentName. The problem I am running into is that one of the columns in the report is counting where the user is the call center agent, not the event agent. Is there a way to ignore the dimension value for the sum, but get the dimension value to use in the new criteria?
Re: Ignore the dimension, but uses it value in a new lookup?
The Dimension of my table is the EventAgentName. For this column, I need to ignore that dimension and calculate over all the data. I tried using a Set Expression, but that doesn't seem to remove the table dimension. Plus, I need to get the value of the current rows dimension, so that I can use it in this query.