filter on field used in set analysis

[kylealpaugh]

When i filter on a field that i use in set analysis it does not filter down it keeps the same value i was wondering if there was any fix to this problem.

Example

sum({1< [Customer]={'EBR*'}>}Sales)

There are multiple customers that start with EBR i want the chart to show all of them which it does but i also need to be able to filter down to see each one of them individually.

Is there any way to be able to do this

Thanks

[sunny_talwar · Accepted solution]

Try this

Sum({1<[Customer] *= {"EBR*"}>}Sales)

Read about * here

Also, use double quotes instead of single quotes for search strings. Read here

Quotes in Set Analysis