Cube formula in excel (Powerpivot) - 2 identical Slicers that won't allow same items to be selected

[Anonymous]

Hi all, 

I have a brainstorm. I want to use cube formlas to create two columns of revenue (for example).

Lets say I have 4 locations. China, US, Europe, Africa with a revneue value for each. 

I can create two slicers, and have each column relate to 1 slicer. What that means then is that I can choose to select CHina, US, Africa in the first slicer, and Europe in the second slicer. This would mean my first column shows China, US, Africa revenue, whilst my second column shows Europe. 

If i unselect US from the first slicer, and select it in the second slicer, the US revenue will move to the secondcolumn. 

I can do the above. 

What I'm stuck on is how to limit the slicers so I CANNOT select the same location twice (i.e. I cannot select US in both the first and second slicer and end up double-counting the revenue when I add up the two columns. 

Can anyone help? Is my question easy to understand?

[v-jiascu-msft]

Hi @Anonymous,

It seems the fields of the two slicers are from one column. Usually when we select one option in one slicer, there will be only one option in the other slicer. Can you share a sample or some snapshots please?

Best Regards,

Dale

[Anonymous]

Hi. Thanks for the reply. 

What i mean is there would be two different pivot tables. One which is only for China, US etc, the other for Europe, Africa. (same set of data).

IF i chose to select Europe in the first pivot table, then i want it to automatically make it so that I cant select Europe in the second pivot table.

DOes that make sense? Now that I say it this way it sounds a bit un-doable :S