Need help with Chart--narrow down the given choices

[#1]

I was given a pivot table that displays 50 corporate accounts along with the rank, and revenue, however I want to take 15 of these accounts and only display the specified 15 and leave out the rest. In other words I need to narrow down the possible choices of the Corporate Accounts from the ones available.

[stephencredmond]

Hi,

Generally this will be as a calculated dimension. What are the criteria?

Stephen

[#3]

There is no criteria, I have a list of accounts that I need to pull by name. So my boss picked the 15 accounts and I need to pull them by name from the list and display only those names. The dimension is called 'Corporate Accounts'.

[prieper · Accepted solution]

As recommended by Steven a calculated dimension should do, like

IF(MATCH(Dimension, 'Dim1', 'Dim2', 'Dim3'), Dimension)

and then tickmark "Suppress when value is Null".

HTH
Peter

[#5]

Thank you very much it worked well. However, now the expression itself shows as the header rather than the name of the dimension, how can I fix this??

[prieper]

Enter something under Properties - General

Peter