Aggregate the fields

[#1]

Hi All,

Please find the attached qvw and test data.

In the qvw there are different fields Generate, Response, Connect, Connect assisted and Close. Each stage sales representatives are involved and corresponding amounts are there.

I need to calculate how much is received by each Sales Representative at all the stages.

Please let me know if you need any clarifications.

Regards,

Keerthi KS

[Mark_Little · Accepted solution]

!Hi,

Take a look at the attached File.

See if this is what you are wanting.

If it is you would want to look at renaming fields and dropping tables.

Mark

[#3]

Hi Mark,

There is no link between the Data table and the Agent, because of that if Agent is selected it will not have any selections in the Data table.

How can we achieve that?

Regards,

Keerthi KS