How to rename pivot table expression value?

[#1]

Hi,

I have expression as below in pivot table

=IF(MIXMATCH([Support],'Client','Sales','Out','In','Expired'),[Support])

I want 'Out' labelled as 'Deleted' in Pivot table. Is it possible.

I need the pivot table shown as below on screen

Location   Client   Sales   Deleted  In   Expired
a                 20       10       1             23    245
B                67       34       56           89    100
C                23       90       78           12    108

Please can anyone suggest me how to set this.

Thanks.

[AbhijitBansode]

sum({<Support={'Client'}>}YourMeasure)  - Lable as Client

sum({<Support={'Sales'}>}YourMeasure)  - Lable as Sales

sum({<Support={'Out'}>}YourMeasure)  - Lable as Deleted

similar for other..

[Anonymous · Accepted solution]

Try this as calculated dimension and check supress null values.

=Pick(MixMatch(Support, 'Client','Sales','Out','In','Expired'), 'Client','Sales','Deleted','In','Expired')

Marc.

[#4]

Thanks. sorry typo mistake. the below I have is dimension not expression 

Dimension

=IF(MIXMATCH([Support],'Client','Sales','Out','In','Expired'),[Support])

the expression I have is common expression as below

expression

=COUNT({<Support-= {' '}>}DISTINCT CustomerID)

how can I change please help.

[#5]

Thanks. That's working.