Skip to Content
avatar image
Former Member

Filtering rows by another variable


Ive been trying this for a while and cant seem to get it.

I have a cross tab with country and state as row headers on the left, and the month as top headers. My values are current sales. The entire report has a filter to only show one month.

However, in this report, I only want to show countries that has an overall efficiency score if more than 60% for this month (this variable is calculated seperately and dependent on month and country, but not state, amongst other items).

Ive tried dragging this extra variable in but i either received a multivalue or a context value when i try for each, for all or in operators.

Anyone has any idea how to do this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers