
1. Re: How do I make fixed LOD calculation ignore a dimension filter?
Ken Flerlage Aug 23, 2018 9:46 AM (in response to Rick Varona)I'm a little confused. Can you mock up an example of what exactly the output should be when you select each of the options in the Type filter?
At this point, my suggestion might be to simply change the Rate calculation so that it uses Prior Year Fixed Nested LOD:
SUM([Amount])/SUM([Prior Year Fixed Nested LOD])
But then just display Prior year Fixed LOD on the view.

2. Re: How do I make fixed LOD calculation ignore a dimension filter?
Rick Varona Aug 23, 2018 11:11 AM (in response to Ken Flerlage)Hi Ken,
Thanks for the quick reply. Basically, I want Prior Year Fixed LOD to remain the same regardless of the filter selection (A or B).
Type filter = B
Type filter = A
In the example above, the grand total rate for type filter = A (bottom screenshot) should be 33% (100/300) not 100%. To your point, the Rate calculation can be changed to use Prior Year Fixed Nested LOD, but then the Rate for product subcategory A in the bottom screenshot would be incorrect (would show 33% instead of 100%).
My understanding is that the Fixed LOD calculation is applied before the dimension filter according to order of operations so would assume Prior Year Fixed LOD would stay the same regardless of dimension filter selection. That does not appear to be the case here. If there's a way to have Prior Year Fixed LOD ignore the dimension Type filter I believe that would solve my issue.
Thanks

3. Re: How do I make fixed LOD calculation ignore a dimension filter?
Rick Varona Sep 5, 2018 1:41 PM (in response to Rick Varona)Can anyone help?

4. Re: How do I make fixed LOD calculation ignore a dimension filter?
Shinichiro Murakami Sep 5, 2018 2:38 PM (in response to Rick Varona)Very confusing..
Could you clarify the expected results by handdrawing table for each filter A/B?
Thanks,
Shin

5. Re: How do I make fixed LOD calculation ignore a dimension filter?
Rick Varona Sep 6, 2018 6:41 AM (in response to Shinichiro Murakami)Apologies for the confusion. Please see below for expected results for filter = A and filter = B.
Type filter = A
Prior Year Fixed LOD calculation = {FIXED[Product Sub Category]:SUM([Prior Year])}
Type filter = B
Prior Year Fixed LOD calculation = {FIXED[Product Sub Category]:SUM([Prior Year])}
I would like the Prior Year Fixed LOD calculation to ignore the type filter (same values if A or B selected). However, Amount needs to change depending on the type filter selection.
Thanks,
Rick

6. Re: How do I make fixed LOD calculation ignore a dimension filter?
Rick Varona Sep 11, 2018 8:35 AM (in response to Rick Varona)Can anyone help?