
1. Re: LOD Used for ManytoMany, % of Total
swaroop.gantela Nov 28, 2018 6:42 PM (in response to none given)I'm not sure if this quite got there, but maybe it can give ideas.
As you had done, I made a field that flags combinations that contain the parameter:
IF [Method]=[Transportation Selection 1] OR [Selected]=[Transportation Selection 1]
THEN 1 ELSE 0 END
Then I made a field that grouped combinations.
If the [Method] that is the same as the Parameter wasn't the one selected,
return what was actually selected. Otherwise just return the [Method]:
IF [Method]=[Transportation Selection 1]
THEN [Selected]
ELSE [Method]
END
So the Denominator becomes:
{ FIXED [Combinations with Parameter]:SUM([Contains Parameter])}
And the Numerator becomes:
{ FIXED [Method]:SUM([Contains Parameter])}
And I filtered out the Parameter using
[Combinations with Parameter]<>[Transportation Selection 1]
Please see workbook v10.3 attached in the Forum Thread:

288864select_v10.3.twbx 42.2 KB


2. Re: LOD Used for ManytoMany, % of Total
none given Nov 29, 2018 10:07 AM (in response to none given)
transportation_example.twbx 12.8 KB
