Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Sum({1<[Customer] *= {"EBR*"}>}Sales)
Read about * here
Also, use double quotes instead of single quotes for search strings. Read here
Try this
Sum({1<[Customer] *= {"EBR*"}>}Sales)
Read about * here
Also, use double quotes instead of single quotes for search strings. Read here