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 .

[#2]

Hi Dreamer,

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.

[rajeshforqlikvi]

Hi ,

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.

[rajeshforqlikvi]

Go to the script level and where you have load the customers table, write a where condition like

Directory;

LOAD Customers,

     AAAAA,

     BBBBB,

     CCCCC

FROM

[Rajesh.xlsx]

(ooxml, embedded labels, table is Mysheet) where Customers<>'Siva';

[#5]

Hi Rajesh,

i should load the customer siva

Nested if is not possible because some millions of customers

but i restrict only in one pivot table

[HirisH_V7]

Hi ,

Like this,

Expression:-

=Sum({<Customer-={'Name to be Removed'}>}Sales)

or else in your back end script where Customer<>Siva;

-Hirish

[rajeshforqlikvi]

Load the Customers table twice and only use customers field in the newly loaded table like below :

Customers:

Directory;

LOAD Customers as CustomersForPivotDimentionOnly,

     FROM

[Rajesh.xlsx]

(ooxml, embedded labels, table is Mysheet) ';

NewCustomers:

Load

CustomersForPivotDimentionOnly

resident Customers where  CustomersForPivotDimentionOnly <> 'Siva':

[Anonymous]

When you restrict Siva and suppress null option, it shound not give you any associative information for Siva.

Could you share your sample app?