Double records in the Expression Part

[Learnerr]

Hi,

I made a table in the front part.

My colums are names,training names,teacher name and my expression is the sum(time) of the education.

The problem is: Some participants took the education from different teacher so the time comes double for those people. How can i make a sepaeration to say that take only 1 teavher for a 1 participant.

Thanks.

[tresB · Accepted solution]

Try:          Sum(Distinct Time) 

[Learnerr]

Yes but i would like to say sum(time) when my dimension"unique teacher"

[Learnerr]

Because some students take same education from different tutors. I would like to say sum(time) when my dimension is a distinct teacher

[tresB]

Since teacher is one of your dimensions, it should work fine. If not, try to explain with an example.

[Learnerr]

In simply how can i write this in the expression part:

One of my dimension: Teacher

Expression: Sum(Time)

I would like to say that sum(time) when Teacher is unique.(distinct)

[tresB]

I am not sure if I understood right, to avoid other dimensions impact - you could right an expression like:

Aggr(Sum(Distinct Time), Teacher) 

[Learnerr]

With this table i tried to explain:

I extract data from SAP. Some participants is recorded to sap that took a training from 2 tutors. I would like to say while calculating  sum (time) tell me only   the time from a single tutor for a participant.