Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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