Field value contains text wrapped in double quotes, how to use in Set analysis

[Anonymous]

Hello,

Some of my field values contain text wrapped in double quotes, e.g., field value = [Revenue "pharmacy"].

I use the field value names to specify which items are displayed in a pivot chart with set analysis. For example,

Sum({<Type = {"Revenue "pharmacy""}>}Value)

Fields values where the name contain the double quotes are not displayed in my pivot chart. Is there a way to specify that the double quotes are part of the name? I've tried wrapping the name in brackets with no luck.

Thank you in advance!

[sunny_talwar]

You can try this

Escape sequences

Sum({<Type = {"Revenue ""pharmacy"""}>}Value)

or this with wildmatch *

Sum({<Type = {"Revenue *pharmacy*"}>}Value)

or this with wildmatch ?

Sum({<Type = {"Revenue ?pharmacy?"}>}Value)