Hi Everyone,
I'm trying to work out this question and I am just not getting very far. I have some data on book titles and their authors/publisher and which location buys them. I have been able to do counts with them all separate, but not altogether. I'm looking for the word 'Training' anywhere in the text string, has to be published by 'Greens' and I want it count distinct by location of sale.
for example: (count(Distinct{<[Publisher]={'Greens'}, [Title]={'*Training*'}>} [Location]))
It is only the wildcard that is causing the issue here the '*training*'. Any help where I am going wrong would help. Also this is in a text box KPI.
