
1. Re: Mix Fixed and Exclude
Zhouyi Zhang Oct 31, 2018 4:18 AM (in response to Maxime Huot)Hi, Maxime
Do you have a sample workbook to share and what's your expected result?
ZZ

2. Re: Mix Fixed and Exclude
Jim Dehner Oct 31, 2018 4:45 AM (in response to Maxime Huot)1 of 1 people found this helpfulgood morning 
yes you can but the syntax would be to nest the 2 lods like 
{exclude [product] : sum( (Fixed [Adress], [Region] , [Period]) : SUM([Values])} )}
and similar for the denominator
since we can't see the workbook can't tell if this will produce the answer you want
Please include your twbx workbook so the answer can be more specific to your need
thanks
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

3. Re: Mix Fixed and Exclude
Ombir Rathee Oct 31, 2018 4:59 AM (in response to Maxime Huot)1 of 1 people found this helpfulTry this :
{Fixed [Address],[Region],[Period]: SUM({EXCLUDE [Product]: SUM([Values])})}/
{FIXED [Period] : SUM({EXCLUDE [Product]: SUM([Values])})}