Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a Table like below. All are dimension. I want to see only Unknown PCP Blended Group Practice Name. That mean I only want to see the member number that has unknown Practice Name. Please suggest.
For the chart above I used this script/data
Load * inline [
Practice name, Blended group, Member number
My doctor, M123, A123
Your doctor, Y123, A234
UNKNOWN, U123, A345
UNKNOWN, o, A456
];
And this calculated dimension
=IF(match([Practice name], 'UNKNOWN')= 0, [Practice name])
For the chart above I used this script/data
Load * inline [
Practice name, Blended group, Member number
My doctor, M123, A123
Your doctor, Y123, A234
UNKNOWN, U123, A345
UNKNOWN, o, A456
];
And this calculated dimension
=IF(match([Practice name], 'UNKNOWN')= 0, [Practice name])