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

    Year on Year calculation on graph


      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.