Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a table of stats split by Region / Sub Region/ Sales Person. I am not trying to show the averages in another table by Region but the avg's are different to what i get if i export the first table into Excel .
Can anyone see what i am doing wrong with the attached?
In excel i get 8.2
Try this expression
=Avg(Aggr(
Count(_%Visit)/Count({<[Image Level], [Group Outlet Type]>}DISTINCT [Worked Day])
, Territory, [Sales Rep], Region))
Try this expression
=Avg(Aggr(
Count(_%Visit)/Count({<[Image Level], [Group Outlet Type]>}DISTINCT [Worked Day])
, Territory, [Sales Rep], Region))
Thanks Sunny, that works!
I have noticed that you have removed the = from the set analysis, was there a reason for that?
Sorry that is just out of habit. Having FieldName = is equivalent of FieldName. You can add that back.