Filters

[Anonymous]

Hi,

Im trying to build a table that will only bring back values of products that have only sold through a certain sales channel. The data set below is a table of products that are listed by sales channel. What i want to do is have a table that only brings back the details of products that only have a certain sales channel listed and none of the others I.e. one table for online and one for trade.

I have tried playin with the filters but i am struggling to achieve this.

EAN	Name	Sales Channel	Volume	Sales	Marign
1	A	Store
2	B	Online
3	C	Trade
1	A	Store
2	B	Online
3	C	Trade
4	D	Online

[judspud]

Hi @Anonymous,

You could have one table which filtered using a slicer on the Sales Channel.

Or you can create the 2 tables and then use visual level filters by dragging the Sales Channel field into the Visual Level Filter section and using basic filtering to only select the relevant Sales Channel for that table.

Thanks,

George