7 Replies Latest reply on Apr 10, 2018 2:23 AM by Tushar More

    average  monthly sales- Total sales/fixed working days

    Shiv PANDIT

      Hi experts ,

       

      I want to calculate per day average sales like below

      sales month

      jan feb march april may ..... dec

      20k 30k 40k 50k 60k ..........1000k

       

      The working days is fixed from management like

      working days

      jan feb march apr may june ..... dec

      25    23 25     26   24    25..........26

      how can i calculate per day average sales .

      I want to calculate like

      20k/25 30k/23 40k/25 etc... for every months

       

      How can i do for this for two years.

       

      Should i make calculate field for this or any other option is available in tableau.

      Please help me.

      Regards

      Shiv