Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Yearly tab only showing current year

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!

Comments

  • 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.
  • That solved my question perfectly. Thanks for your prompt response!!! Keep up the great work!
Sign In or Register to comment.