2 Replies Latest reply on Dec 4, 2018 7:00 PM by Jeff Labenek

    YTD and Full Year Button

    Jeff Labenek

      Good Morning,

       

      I'm working on a dashboard and am curious to know if there is an easy way to create a button in my dashboard to filter a table and chart based on year to date (actuals) and full year?

       

      Please see attached a dummy workbook with a dashboard showing a table of actual vs budget, a monthly trend bar graph comparing actual vs budget and a filter button to drill down into types of costs. I was trying to create a filter button similar to the existing "O&M & Salary" button for the YTD and full year that would update the table and graph but have not been able to get a calculation to work. If anyone has solution it would be greatly appreciated.

       

       

      Thanks!

      Jeff