Filters function

[louise119]

Regarding filters.
I have a filter with 5 conditions, and I want to display only 3 results in the table and 5 results in the graph. Is it possible to do it with one sheet?

FilterA  |  FilterB  |  FilterC  |  FilterD  |  FilterE


I wanna use the result of FilterA and FilterB and FilterC for chart.
and also I wanna use the result of FilterA and FilterB and FilterC and FilterD and FilterE for graph.

[vinieme12]

in the Chart:

ignore selections made in FilterD and FilterE  in the measures as below

sum({<FilterD=,FilterE=>} Sales)

[louise119]

thank you. I used set analysis, is this only available for numbers?
I want to output data (string) regardless of filters.

[vinieme12]

Your Table will naturally return relevant records as filtered by any Measures in the tables

any string fields need to be added as Dimensions

OR 

You can filter a dimension by using a calculated dimension instead(this will impact the performance however, so it's advisable to filter records in the measure) 

A calculated dimension needs to be wrapped in AGGR()

eg.  =  AGGR(  Only({<FilterD=,FilterE=>} KeyField) , KeyField)

[louise119]

thank you.

I tried the below  nothing showed up....the list only showed  hyphen.
Do you have a page that might be helpful?

[formula]
・AGGR( Only({<FilterD=,FilterE=>} KeyField) , KeyField)