Ignore Selections on a Chart - Pivot Table - "No Measures"

[ltc]

Hi everyone,

I need a pivot table to ignore selections of the following fields: [Rating] [Date] [Progress] and [Is Current].

I know to normally add {1} to set analysis in the measure, but this pivot table doesn't use a typical measure with a sum/count/avg/etc. function, so I don't know how to incorporate set analysis into it and use {1}.

These are my dimensions/measures:

Row Dimension: Category
Column Dimension: Date
Measure:
= If(IsNull([Rating]),'Not Rated',[Rating])
& ' ' &
Pick(WildMatch([Progress], 'Steady Performance', 'Negative Performance', 'Positive Performance') + 1, '', chr($(ASCII.RightTriangle)), chr($(ASCII.DownTriangle)), chr($(ASCII.UpTriangle)))

Note: I have my chart calculation condition set to GetPossibleCount([Program]) = 1

I'm attaching a sample data set and screenshot of what the pivot table looks like.  The pivot works as is, but again, I don't want it to respond to selections of the fields mentioned above.  I would also be okay with an expression that keeps the pivot table from responding to selections of any field.

Please help!  Thanks!

[Anil_Babu_Samineni]

You can try this way?

= If(IsNull([Rating]),'Not Rated',[Rating])
& ' ' &
Pick(WildMatch(Only({<[Rating]=, [Date]=, [Progress]=, [Is Current]>} [Progress]), 'Steady Performance', 'Negative Performance', 'Positive Performance') + 1, '', chr($(ASCII.RightTriangle)), chr($(ASCII.DownTriangle)), chr($(ASCII.UpTriangle)))

[ltc]

That didn't work.