4 of 4 people found this helpful
Create a calculation that is index()!=1
Add this into the view, ensure the compute using is set to Table Across, put it on the filters shelf and keep the True value. This will server to always hide--rather than filter--the results for the first displayed month in this example. Hiding the month allows us to still get results from the database which are required to calculation the percent difference. If you filter November, we can no longer calculate the percent difference as we no longer receive the necessary data.
You can also right click on November and choose hide but this will not by dynamic like this calculation.
Hope this helps,
Perfect, thanks for your help.