3 Replies Latest reply: Jun 12, 2013 4:08 AM by Jan Vesely RSS

    Partial sum in pivot table

      Hi everyone,

       

      I have a small issue (perfectly understandable though) in QV with parital sums in my pivot table (see screenshot below).

       

      The number in the last column (# of tags) is based on an expression. The expression counts unique codes using simple count(fieldName). All good so far.

       

      However, some of the codes have been detected on multiple days - this causes the partialSum to be indeed a count of unique codes but not a sum of the numbers above it. Because it is an expression, I cannot define accumulation / total mode. I also cannot switch to "calculated dimension", as count(fieldName) delivers //calculation error when used as dimension.

       

      How can I solve this? Is there a way to solve this?

       

      Thanks in advance!

       

      meuk.png