6 Replies Latest reply on Sep 26, 2017 6:11 AM by Jayshree Dawrewar

    Dynamic sheet title based on axis hierarchy

    Vivek Nayagam

      Hi,

       

      We have a line chart with date field in X-axis and measure on Y-axis. We are using the +/-  buttons on axis to drill down / drill up to change date field to year, quarter, month level etc.

      Based on the level of date, is there a way to change the title of sheet to say - 'Sales by Quarter' / 'Sales by Year' and so on (without the use of parameters)? Please refer attachments for more details.

       

      Thanks,

      VN