1 Reply Latest reply on Mar 5, 2017 9:44 PM by gopi duppati

    Year on Year calculation on graph

    sunil.sachdeva

      Hi All,

       

      I have created a dashboard with YoY comparison data, please find attached workbook.

      I want to see current month data as Bar and Prior Year data (Same month - last year) as line to have YoY comparison.

       

      there is second sheet showing underlined data for selected month, could someone please help in:

       

      a) how can i show previous year data in data sheet for selected month (in separate row, not in another column)

      example if i select Feb-17, data row should show 2 rows , one for Feb-17 and another for Feb-16.

       

       

      img.png