11 Replies Latest reply on Sep 20, 2016 7:07 AM by richard.sonkane

    How to calculate average based on max denominator

    Emily Z

      Hi,

       

      I've been struggling how to average data based on max denominator in the same category. e.g. pls. refer to below table, the result I want is in the column 'Average Order'. i.e. Average for O5 = (1+0.5)/12 because O2 has 12 months of data. Is there any way that Tableau can achieve this? I attached an excel file with formulas. Kindly help!

       

      CategoryOrderAPR-2015MAY-2015JUN-2015JUL-2015AUG-2015SEP-2015OCT-2015NOV-2015DEC-2015JAN-2016FEB-2016MAR-2016Avearge Order% of Total
      AO21.01.01.01.00.91.01.00.90.81.00.90.70.9288.1%
      O51.0 0.5 0.1311.9%