
1. Re: Using Table Calculation Results as filter while retain certain data
Simon Runc Dec 17, 2015 9:01 AM (in response to ming.ticchione)hi Ming,
Yes I'm pretty sure we can help here...the trick is to create a calculation for each of your months, and then use the measure names/values to display them how you want.
Hard coded the formulas would be
[Sales Feb]  and bring in as AGGREGATE SUM
IIF([Month] = 'Feb', [Sales],0)
[Sales Jan]  and bring in as AGGREGATE SUM
IIF([Month] = 'Feb', [Sales],0)
variance is
SUM([Sales Feb])  SUM([Sales Jan])
Now this isn't very dynamic (you'll need to change the formulas each month). So we can create a Month Index (an use that in place of the 'Jan'/'Feb')...if you look at my post here it shows you how Re: Filter values up till current month
Hope this makes sense, but if not please post back. If you can post you workbook, I can create the calculations in there and give you an 'exact' solution.

2. Re: Using Table Calculation Results as filter while retain certain data
ming.ticchione Dec 17, 2015 8:49 AM (in response to Simon Runc)Hi Simon,
Thank you for your quick response. This is very helpful!
Ming