1 Reply Latest reply on May 16, 2016 8:06 PM by Andrew Connolly

    Hiding Months Without disturbing calc YoY fields

    JayC

      All,

      I have calculated YoY% using Lookup function and am using those fields in the trends line chart.

      There is no YoY% calculated for previous months lacking data, thereby view for the first few months is blank/missing and showcases the view like the one attached-

       

      I would like to restrict the view with latest 12 months to be displayed but unfortunately its taking away my calculated YoY fields.

      Any chance i can have YoY% fields intact and also have only latest 12 months displayed.

       

      Please help.