AnsweredAssumed Answered

Summary calculation

Question asked by walterbz on Feb 22, 2019
Latest reply on Feb 23, 2019 by walterbz

Hi all,

need help with a summary calculation.

I have a simple table with:

event | category | person | date

The table is populated by name of persons that belong to a category that belong to an event

Example:

EventA | CatA | Mark | dateA

EventA | CatA | Mark | dateB

EventA | CatA | John | dateA

EventA | CatA | John | dateB

EventA | CatA | John | dateC

EventA | CatB | Mark | dateA

EventA | CatB | Mark | dateB

I need a summary report where I can see:

EventA 7 occurrences

-CatA 5 occurences

-CatB 2 occurences

I am able to do this with partial summary sections and summary field.

But I need also to have the number of people present:

EventA 7 occurrences - 3 persons

-CatA 5 occurences - 2 persons

-CatB 2 occurences - 1 person

I can't find a way to do this.

Thanks in advice for help.

Walter

Outcomes