Set Analysis - Ignore all selections except certain field

[#1]

Hello,

I'm trying to figure out how to calculate the sum of a measurement, disregarding the selections in all the fields except a certain field.

Let's assume the following fields:

Year, Person, Section, Sales. I would like to calculate the Sum of Sales, disregarding the selections at all fields but regarding the selections made at the "Person" field.

The expression:

SUM({1<Person=>}Sales)

Will not due the trick as the result will not change according to the selections made at the "Person" field.

Does anyone as a suggestion?

[Mosnofa]

Good night,

I was trying to calculate the market share of the sales of a campaign, but for my denominator I am trying to ignore the selection of the campaing and consider the category of the campaign as my universe.

I want to ignore the Campaign_Designation but at the same time allow Category_MaisFarmacia_Source find the category of the campaign

My denominator is :

Sum( {<
$(vSetPreviousYearToDate)
, Fact_Source_Code = {SOS}
, [_Product_Master_Is_Partner_F] = {"*"}
, Product_Master_Counseling = {"***"}
,[_Product_Is_Generic_F]={"*"}
,Product_Price_Type_Code={1}
, _Pharmacy_Is_Associate_F={"*"}
,Campaign_Designation=
, Category_MaisFarmacia_Source = P({<[Campaign_Designation] = {"*"}>})
>}

[#SellOut_Units]*$(vSwitchCampaignOverTime)
)

Can you help me ??

Best Regards 

Mosnofa