Keeping selected records and adding new ones to a selection...

[jerryr125]

Hi everyone - 

I have a question in regards to selecting records in a table visualization.  
Is there a way to accomplish the following :

For example - I sheet with a couple of filters and a table visualization displaying product name and other information about the product (simple).  Say there is 1000 products.

Using the filter "Product name", the user filters on the product name "Wood Table" and the table visualization displays 50 products (50 lines) in the selection.  

Now the user wants to select more products and NOT lose the result set of the 50 "Wood Tables". 

Is there a way to accomplish this ?

For example, now the user wants to select Product name "Red Chair" in which there is 25 red chairs. Therefore the total result set is 75 products.

I have been doing some research - maybe alternate states ?

Not sure - any insight would be helpful - thanks so much - Jerry

[jerryr125 · Accepted solution]

I think my answer may by with alternate states...

This is what I am looking to do:

https://youtu.be/gS4XWmE4JX0

[mikaelsc]

use an expression to exclude your selection on salesID in your first table: 

sum({<salesID= >}QuantitySold) 

? 

[jerryr125]

Hi - I am working on a solution using extensions - stay tuned - Jerry

[JeffMelon]

@jerryr125 Did you ever find a solution for this? I watched your video explaining the objective and I am looking to do the same.

Thank you