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