4 Replies Latest reply: Jun 26, 2015 3:57 AM by sujeet singh RSS

    Straight table Help

    sujeet singh

      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