9 Replies Latest reply: Mar 31, 2014 7:44 AM by Markus Mortsiefer RSS

    Percent of Distinct Total in a pivot table

    Markus Mortsiefer

      Hallo,

       

      If some could help me i need the Distinct total of VOC per Month.

       

      Current Expression

      =count(VOC) / count(total <VOC> month(TARGET_DATE)) as Percent

       

      The correct percentage for the first record should be 35,4 which is 495/1325

      Capture.JPG.jpg