I am looking for an expression that will help me calculate the average TAT for only the unique Doc No.
Please view sample data
Doc No as a Dim
may be this as well?
=aggr(avg(TAT), DocNo) as Expression
hope it helps :
I need a solution to the below data that will show one Average in a Text box.
It must only do a calculation for the unique Doc No.
Did you try what I suggested you??
Retrieving data ...