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 .
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.
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.
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';
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
Hi ,
Like this,
Expression:-
=Sum({<Customer-={'Name to be Removed'}>}Sales)
or else in your back end script where Customer<>Siva;
-Hirish
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':
When you restrict Siva and suppress null option, it shound not give you any associative information for Siva.
Could you share your sample app?