Straight table Help

[sujeetsingh]

Hello All,

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

[#2]

Have you checked with Total, Count(distinct BrandID)/count(Total Distinct BrandID).

[hariprasadqv]

Hi,

Write Expression for average in Expressions tab.sum(Values)/Count(Values)

Thanks

[sujeetsingh]

I want the total at each row

[sujeetsingh · Accepted solution]

Achieved it with Range sum and rank function.