
1. Re: Show values of filtered dimesion
Shinichiro Murakami Nov 23, 2016 2:31 PM (in response to Philip Perrin)Not sure this logic works or not, anyways.
You already have enough fields to calculate in/out with LOD, then I just added one more calculated field for amount and percentage respectively.
[Percent of Total (UNSelected Regions)]
(sum([{SUM(Small Sales)} ])Sum([{SUM(Small SalesRegion)}])) / SUM([{SUM(Sales)} (Whole) (Region)])
BTW, just for curious, is version 10.1 already released?
Thanks,
Shin

Split LOD function_SM_10.1.twbx 310.8 KB


2. Re: Show values of filtered dimesion
Philip Perrin Nov 28, 2016 9:05 AM (in response to Shinichiro Murakami)Thanks Shin 
I appreciate the response! Unfortunately this doesn't quite fit what I'm looking for.
In the screenshot you posted, you had unselected "East." The desired outcome would be a measure (Percent of Total (UNSelected Regions)) that displays the percent of small sales of "East." Likewise, if "East" and "South" were unselected, then the measure would aggregate the percent of small sales within those two regions and display the overall percent of small sales from those two regions.
The point is to allow me to compare three key measures: overall small sales as a percent of all sales (black line), selected regions' small sales as a percent of all sales in those regions (orange line), and the unselected regions' small sales as a percent of all sales in those unselected regions (red line).
I'll keep tinkering with the formulas as I'm sure there is a way to get at this.
As for 10.1  Looks like it was initially released on 11/1, with an update on 11/6. I believe I manually went to the customer portal and updated while at TC16.
Again  thanks for looking into this!
Phil

3. Re: Show values of filtered dimesion
Shinichiro Murakami Nov 28, 2016 5:57 PM (in response to Philip Perrin)Hi Philip
I understand your request and revised the file.
You can simplify some of fields which you don't need to use LOD.
[Order Date (month)]
date(datetrunc('month',[Order Date]))
[SM_ALL R Small]
{fixed[Order Date (month)] :sum([Sales of only Small Sales])}
[SM_ALL R Small / Whole]
attr({fixed[Order Date (month)] :sum([Sales of only Small Sales])})
/
attr({fixed[Order Date (month)] :sum([Sales])})
[SM_Selected Small] // you don't need to use LOD, because it's already filtered.
Sum([Sales of only Small Sales])
[SM_Selected Small / Whole]
Sum([Sales of only Small Sales])/sum([Sales])
[SM_UNSelected Small] // whole (LOD) minus selected( filtered)
attr({fixed[Order Date (month)] :sum([Sales of only Small Sales])})
Sum([Sales of only Small Sales])
[SM_UNSelected Small / Whole]
(attr({fixed[Order Date (month)] :sum([Sales of only Small Sales])})
Sum([Sales of only Small Sales]))
/
(attr({fixed [Order Date (month)]:sum([Sales])})
Sum([Sales]))
Change filter to context to apply filters before LOD.
Thanks,
Shin

Split LOD function_SM_10.1_V2.twbx 346.7 KB


4. Re: Show values of filtered dimesion
Philip Perrin Dec 6, 2016 8:43 AM (in response to Shinichiro Murakami)Thanks Shin 
Not only is this a correct and helpful answer  but it also helped me gain a better understanding of how to make these calculations.
Thanks!!
Phil

5. Re: Show values of filtered dimesion
Shinichiro Murakami Dec 6, 2016 9:03 AM (in response to Philip Perrin)You are very welcome and that's the way this forum works!
Enjoy!
Thanks,
Shin