Partial Sum is showing incorrect in pivot table

[kapil_rthr]

Hi 

Not able to understand why the partial sum is showing incorrectly in the attached figure where as the sum of the productivity column for user 1 should be 66 but its showing wrongly as 58.

[sunny_talwar · Accepted solution]

Try this

RangeSum(
  Count(DISTINCT {<SEVERITY = {'Blocker'}>} ISSUE_KEY) * 4,
  Count(DISTINCT {<SEVERITY = {'Major'}>} ISSUE_KEY) * 3,
  Count(DISTINCT {<SEVERITY -= {'Blocker', 'Major'}>} ISSUE_KEY) * 2
)

or you can try this

Sum(Aggr(
If(SEVERITY = 'Blocker', Count(DISTINCT ISSUE_KEY) * 4,
If(SEVERITY = 'Major', Count(DISTINCT ISSUE_KEY) * 3, Count(DISTINCT ISSUE_KEY) * 2))
, ASSIGNEE, SEVERITY))

[kapil_rthr · Accepted solution]

awesome, it worked. thanks a lot.