I recently migrated to version 2 work book. However, the yearly tab now only shows the 2016 year. However, in my old v1 workbook I am able to see my history back until 2014 which is when my data begins. Any idea why?
In the Yearly tab at the top right just after "ReportCurrency" slicer there is slicer "Years-Current". By default value on this slicer is set to "Yes". Remove selection from this slicer and report will show last 5 years. Years calculations are most "expensive" (time consuming) so by default you see just one year, but any time you need to look closer in year over year performance, then just click on this slicer.
Comments
Years calculations are most "expensive" (time consuming) so by default you see just one year, but any time you need to look closer in year over year performance, then just click on this slicer.