Skip to Content

Filtering rows by another variable

Oct 26, 2017 at 07:45 AM


avatar image


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?

10 |10000 characters needed characters left characters exceeded

can you share some sample data plz.

* Please Login or Register to Answer, Follow or Comment.

0 Answers