Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
May be this:
If(not WildMatch([Receiver Name], '*siva*'), [Receiver Name])
Replace customer dimension with a calculated dimension: If(customer <> 'siva', customer)
alternatively you can use set analysis in your expression: {<customer -= {'siva'}>}
Hi Sunny
=IF([Receiver Name]<>'*siva*',[Receiver Name])
i can see only siva remaining is not coming
Dont forget to tick Suppress Null Values option as well
May be this:
If(not WildMatch([Receiver Name], '*siva*'), [Receiver Name])
try like this:
=if(not [Receiver Name] like '*siva*', [Receiver Name])
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 )
Did you check Suppress with Null Values option in dimension tab?
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.
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,