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 .
Thanks for the quick response
if i am using New_Receiver_Name it is showing blank i need to surpress null values know .
i am using pivot table in which 5 (dim) i want to expand only 3 by default if it expand's for their shape is change how to get read of it.
If you have limited customers like not more i mean 5 to 10 then you can use nested if condition like below
If( Customers = 'AAA' , 'AAA',
If (Customers = 'BBB' , 'BBB',
If(Customers = 'CCC' , 'CCC')))
Include all customers in the nested if condition except customer = siva.
Go to the script level and where you have load the customers table, write a where condition like
(ooxml, embedded labels, table is Mysheet) where Customers<>'Siva';
Load the Customers table twice and only use customers field in the newly loaded table like below :
LOAD Customers as CustomersForPivotDimentionOnly,
(ooxml, embedded labels, table is Mysheet) ';
resident Customers where CustomersForPivotDimentionOnly <> 'Siva':