Hi All -
I have created a time intelligence measure that calcs YOY growth as a percentage. The issue I am seeing is that when I insert it into my pivot table (and ultimately my pivot chart), it is showing data points for future months. For instance, I want to refresh the pivot each month when the new data becomes available. This month, we have data through July 2016. However, the since I've added the measure, there is a -100% value showing for Aug, Sept, Oct, etc. How can I remove these so these future months aren't showing in my pivot chart? As an aside, the chart should show the previous 13 months worth of data.
Thanks
I have created a time intelligence measure that calcs YOY growth as a percentage. The issue I am seeing is that when I insert it into my pivot table (and ultimately my pivot chart), it is showing data points for future months. For instance, I want to refresh the pivot each month when the new data becomes available. This month, we have data through July 2016. However, the since I've added the measure, there is a -100% value showing for Aug, Sept, Oct, etc. How can I remove these so these future months aren't showing in my pivot chart? As an aside, the chart should show the previous 13 months worth of data.
Thanks