Table / Pivot Table with permenent filter

[#1]

Hi.

Is there any way to create Table / Pivot Table with permanent filter?

I have an Excel spreadsheet with lots of data

NAME	TYPE	JAN	FEB	MAR	…
name1	type1	482	488	467
name1	type2	231	237	216
name1	type3	0	6	-15
name2	type1	14	20	-1
name2	type1	141	147	126
name2	type1	598	604	583
name2	type3	239	245	224
name2	type3	0	6	-15
name3	type2	7	12	-8
name3	type2	865	871	850
name3	type2	-84	-79	-99

On the same slide I have multiple tables and charts using the same data.

How do I add to the same slide a net Table / Pivot Table which would use the same data but which would only show "name3"?

I'd like to input permanent filter only for this new Table / Pivot Table so it always showed only "name3" and its value.

At the moment filtering any of the charts or tables limits all other in the same app.

[danansell42]

Try using set analyis

for example:

SUM( {<NAME = {'name3'}>} JAN)

[danansell42 · Accepted solution]

Another alternative is to add an if statement as the dimension field.

for example:

IF(NAME='name3',NAME)

also un-tick the show null values box

this should then give the desired result

[#4]

Thanks a lot Daniel, that helped!