Forum Discussion

ScottKC's avatar
ScottKC
Frequent Visitor
1 year ago
Solved

Controlling interactive filtering across visuals

Hi champs,

 

My report contains:

- a Matrix visualization with "Departments" on the rows, "Months" (for last 12 months via Filter on the visual) on the columns, and "Sales" on the cells.

- a Table visualization listing "Customers" and "Sales" sorted by High to Low (with no time Filter on this visual).

 

With the normal interactions I can click on a "Department" in the Matrix and it interactively filters the Table to show the Customer Sales from that match. However, this is only showing Customer Sales that match thte Matrix and only where they're also within the last 12 months (as per the Filter on the Matrix).

 

Is there are a way to change the interaction, so that if I click on "Department" in the Matrix the Table will show Customer Sales within that Departmant based on all time sales and not just sales within the 12 months?

 

Hopefully that makes sense.

Cheers

1 Reply