Restrict a user name in pivot table

[#1]

Hi All,

I want to restrict a particular customer name in a pivot table dimension.

i am using customer in pivot table as dimension i don't want to see customer=siva in that chart .

[sunny_talwar]

Replace customer dimension with a calculated dimension: If(customer <> 'siva', customer)

alternatively you can use set analysis in your expression: {<customer -= {'siva'}>}

[#3]

Hi Sunny

=IF([Receiver Name]<>'*siva*',[Receiver Name])

i can see only siva remaining is not coming

[Anonymous]

Dont forget to tick Suppress Null Values option as well

[sunny_talwar · Accepted solution]

May be this:

If(not WildMatch([Receiver Name], '*siva*'), [Receiver Name])

[Anonymous]

try like this:

=if(not [Receiver Name] like '*siva*', [Receiver Name])

[#7]

Hi Sunny,

Thanks

Receiver name is coming blank but for the siva customer profit and income is coming

i want to restrict siva profit and also income (that is written  in expression )

[Anonymous]

Did you check Suppress with Null Values option in dimension tab?

[#9]

Hi Balraj,

i had supress null values

i want to restrict customer siva name(dim) and it s income and cost also in (expression)

i dont want to show siva and it associative values in expression.

[PrashantSangle]

Hi,

Another solutions can be

Create new field in script which excludes siva from Receiver Name

try like

if(not wildmatch([Receiver Name],'*siva*'),[Receiver Name]) as New_Receiver_Name

and use New_Receiver_Name as your dimension.

Note: You can achieve the required solution suggested by Sunny Need to tick supress Null from dimension.

     Also Conditional  Dimension is performance Killer.

Regards,