Pivot FILTER exclude quotation mark character

teknet9 — Tue, 29 Sep 2020 19:23:16 GMT

Hello Team,

I do have a pivot:

| pivot xxxxx RootObject count(RootObject) AS "Count of admin_adminsearch_RMD578e1308ec259874c_at_1525123982_13769" SPLITROW User AS User FILTER User doesNotContain 'mmm' SORT 100 User ROWSUMMARY 0 COLSUMMARY 0 SHOWOTHER 1

I am using FILTER command to exclude all usernames which include mmm.
But i need to exclude usernames which include quotation mark character: "

How to do that ?

Thanks,
Michal

topic Pivot FILTER exclude quotation mark character in Getting Data In

Pivot FILTER exclude quotation mark character