This content has been marked as final. Show 4 replies
I am struck up in a small expression.
I am using s straight table where i have a calculated dimension
FirstSortedValue(Brand,-[SaleDate] & BrandID & [RowNo()])) as primary dimension and Year as secondary dimension.
Now i need to calculate average as
Brand Year Count( distinct BrandID) Avg
Levis 2011 2 2/2+3+7
Lee 2011 3 3/2+3+7
Mufti 2011 7 7/2+3+7