Question about distribute the dashboard

[#1]

Hi,

I have a problem about distribute the dashboard.

The QVD file is like below table:

Mail  Group  Score

A     1          3

B     1          4

C     2          5

I want to distribute the dashboard by mail, and show the score for each person and his group.

For example, A will get a dashboard like this:

mail address: A

personal score:3

group score:7

The problem is: If I don't use the reduce in the distribution, everyone will get the same dashboard like A.

If I reduce by the field 'mail', the mail address will be OK, but the group score will equal to personal score.

Looks if I use reduce, the dashboard will only load one person's data.

Could anyone help on this?

Many thanks.