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

    Percent of Distinct Total in a pivot table

    Markus Mortsiefer



      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