Yearly tab only showing current year

emteedubs

Hi,

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?

Thanks!

VidasMatelis

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.

emteedubs

That solved my question perfectly. Thanks for your prompt response!!! Keep up the great work!