9 Replies Latest reply on Aug 23, 2018 12:20 PM by Béatrice LORIOT

With or without 1 dimension only

Hi all,

I just can't figure out this one :

I have a list of people and their respective number of sales

John     5000

James  2000

...              ..

David    1000

I would like a simple filter that proposes

"with James" (and total amount with James)

"without James"(and total amount without james), and not all.

Or which would be the same :

"All"

"without james".

Thanks

Best

Béa

• 1. Re: With or without 1 dimension only

I have created a sample for you. Please have a look and let me know if this works.

• 2. Re: With or without 1 dimension only

Thanks so much ! That will work !

But I am afraid I was not clear enough Sorry for that

Could we create a filter that would work directly on the dimension, so that I can apply to any measure in the data base, not only Sales.

Through groups or sets ??? I tried though but could not find out the correct way to do it

• 3. Re: With or without 1 dimension only

How are you choosing James? Is he the only one you want to choose or do you want people to be able to choose any person? I guess I'm unclear as to what the difference is between this and a standard filter.

• 4. Re: With or without 1 dimension only

I want to exclude James from the total (but without having to scroll through a full list of 3000 sales guys )

The filter would be

All (=with James)

Without James

Let's imagine James screws up all the stats for any reason, I want to be able to see with and without James.

Thanks :-)

• 5. Re: With or without 1 dimension only

Hi

Create a quick Filter on SalesPerson column and choose the option of exclude. Please find the snapshot below with details worked out. I have made filter wildcard match which basically lets you type the name and search.

• 6. Re: With or without 1 dimension only

If you just want the 2 options, parameters are easiest. You would just provide the 2 options as above - 'All' and 'Without James'. Then a calculation that points at your parameter:

IF [Sales Guy Parameter] = 'All' THEN 1

ELSEIF [Sales Guy Parameter] = 'Without James' THEN

(IF [Sales Guy] <> 'James' THEN 1 ELSE 0 END)

ELSE 0

END

Then just place this on filters, and keep only 1 values.

Alternatively, you could just place [Sales Guy] on Filters, and checking the Exclude option. This would allow you to check anyone you wanted to exclude from the data. It provides a better alternative if you're not sure which people you may want to exclude in advance.

• 7. Re: With or without 1 dimension only

Hi there,

The alternative solution you are offering is what I am trying to avoid (we would have a list of thousands of sales guys around the world to scroll down).

I really want to see 2 views only and the parameter option you are offering is certainly what I am looking for :-)

But, I have been struggling with the calculated field and formulas, could you confirm what they would be.

Thanks so much, your help is much appreciated !

Béa

• 8. Re: With or without 1 dimension only

If you have an issue with the calculations I proposed, let me know.

• 9. Re: With or without 1 dimension only

Sorry, I got mixed up in the answers :-(

Thanks so much, your help is much appreciated !

Unfortunately, this is what I am trying to avoid. I would like to avoid showing hundreds of employee names and just offer 2 options, without details

Thanks again,

Béa