Counting values / subtotals in tree-structure

Hi,
I have a question regarding the way Pivot counts values when multiple fields is selected as rows.

In this example i would like a list of departments and their total count of client, along with the ability to drill down to see how clients are distributed among employees. Much like you would in an Excel Pivot…

Example…raw data is a list of clients with ID, department and employee. Values in configuration is ID(count)

• Department1: 2 ← “Problem”

  -Employee1: 50

  -Employee2: 50

  -Employee3: (blank)

I would expect “Department1” to be 100, but it seems that Pivot counts the number of employees that have an actual value, which is 2.

Am i missing some config-option, or is Pivot just working this way?

Hi,

We agree with you - the count for folders should sum values of its child rows. We will include the fix into the next Pivot update. If you have a support subscription and need the solution ASAP, please open a ticket in the “members’ area” - we will send updated version.