Hello VA Users, I use VA 7.1 version. I have built a crosstab as below. Each customer is assigned to one salesman. However, in each year the assignment can change. year 2013 2014 2015 customer 1 4 23 15 customer 2 7 35 20 customer 3 9 6 9 customer 4 7 12 21 customer 1 Salesman_X Salesman_X Salesman_X customer 2 Salesman_X Salesman_Y Salesman_Y customer 3 Salesman_Y Salesman_Y Salesman_X customer 4 Salesman_X Salesman_X Salesman_Y I need to filter the table to get customers who are assigned to the Salesman_X in 2015 but I would like to remain results for 2013, 2014 and 2015. So the result table should remain rows with customer 1 and 3. When I try to filter the table by year (2015) and the Assignment (Salesman_X ) I get customers 1 and 3 but columns with 2013 and 2015 disappear. I have no idea how to filter rows by conditions for a specific year. I have also tried to use a combination of drop down lists and parameters but with no success. Would you have any suggestions?
... View more