1 Reply Latest reply on Apr 25, 2018 7:54 AM by Jim Dehner

    Limit Axis to past 10 years?

    Jason Hanser

      I have workbook (sorry, can't share because of confidentially issues) that shows the running count of employees using a running total table calculation. Rather than showing the number of employees since the beginning of time, I want the chart (area graph) to just show the past 10 years. However, I can't filter on date as that would mess up the table calculation. Is there a way to limit the x-axis to the 10 prior year (from whenever I run dashboard)?

        • 1. Re: Limit Axis to past 10 years?
          Jim Dehner

          Since you can't show a workbook I can only give you a conceptual answer

          Place your date on the filter shelf and set to context - that will lock in the data for the period - the you can apply a filter without affecting the calculation

           

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          1 of 1 people found this helpful