2 Replies Latest reply on Mar 26, 2018 3:24 AM by nataraj.vijayanagaram

    Table chart with KPI on only latest year column

    nataraj.vijayanagaram

      Hello Experts,

       

      I would like to know if there is a way to create a table chart based on year on year sales and show a change kpi indicator based on first year to latest year sales change.

       

      Below is a sample I have from excel using the sample store.

       

      Image.jpg

       

      Here I would like order date as year on year sales by sub-category and show KPI only for latest year in the dataset based on change from initial year.

       

      Can anyone please advise how to do this..

       

      Thank you!