2 Replies Latest reply on Nov 8, 2018 4:09 AM by Zhouyi Zhang

    Days Calculation of 1st, 2nd, 3rd Ten Million Sales from super store data

    venkat venkat

      Hi,

       

      I'm trying to construct a visual such that it should show the number of days required to achieve first 10 million sales, next 10 million sales and so on.

      The screen shot will be something like this. I'm able to construct the bars but need the days taken in labels dynamically. Here I manually calculated and annotated.

      This is the calculation written.

      Workbook attached. Please check.

       

      Thanks,

      Venkat.Shinichiro MurakamiZhouyi ZhangSimon RuncSankarmagesh Rajan