Need help Please advise
Im looking for data to be filtered using data sets.
Basically its all coming from one table however it has column called type
Type has values ( 1,2,3,4,5,6,7)
I have to create a dataset A where it includes the data from table but however it should filter data for type = 1,2
similar other data set B where it should include data only for type 3,4
third data set C which should include type all (1,2,3,4) but not (5,6,7)
please find attached picture where A B C D are data sets and below is table with columns when I click on A below table should show results based on A similarly with B
Can we create such data sets with the script
As of now my script is select * from table
