Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a Pivot table which shows the results of the sales of my company. Currently I only have one dimension (Product) so the Table shows the sales by product of all the customers with no distinction at all. My intention is to create another table, similar to this one, but adding a new dimension (Customer Code). And i want it to display the result of only three customers (Let's say: CNA001, CNA002 and CNA003). I dont want to write a different script to this table reducing the customers. So how should I set the dimension? Is there any function similar to an array that let me do something like that:
Management.CustomerCode = function('CNA001',CNA002','CNA003)
I alsa must say that I don´t want to place a external selection field in the same sheet. This customers are always the same so I don't want to have to choose everytime.
Hope anybody can help me. Thanks a lot.
Hello.
You could use a calculated dimension for CustomerCode. For example if(CustomerCode = 'CNA001' or CustomerCode = 'CNA002' or CustomerCode = 'CNA003',CustomerCode).
Hello.
You could use a calculated dimension for CustomerCode. For example if(CustomerCode = 'CNA001' or CustomerCode = 'CNA002' or CustomerCode = 'CNA003',CustomerCode).
It works!! Thanks a lot!!