
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Table / Pivot Table with permenent filter
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.
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try using set analyis
for example:
SUM( {<NAME = {'name3'}>} JAN)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a lot Daniel, that helped!
