Sum of Distinct

[#1]

Hi

I have a variable named as vTAT

I have to find the sum of vTAT based on DISTINCT MAR

MAR                vTAT

123454                 1:23

123454                  1:23

123456                 4:15

1234566                 5:17

Regards

Senthil

[#2]

Attachment Missing

[rubenmarin]

I see the "Test.qvw" in the previous post, anyway, I upload it again.

[#4]

Hi

Below is my Requirement

Dimension - > Date

Need to find the average of Time Diff between EndDate and Start Date for Distinct MAR

In the Attached file the average should be 45:35:50

Note: Source file attached as excel in Distinct Sum

Regards,

Senthil