Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
Generally this will be as a calculated dimension. What are the criteria?
Stephen
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'.
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
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??
Enter something under Properties - General
Peter