5 Replies Latest reply: Feb 19, 2018 5:37 PM by David Forest RSS

    Dynamic dimension

    kvp kumar

      Hi friends

       

      I were struck in creating the dynamic dimension by an expression with a category.

      i.e Category as A,B,C,D,E.

      I need to create a pivot table how many employees having average value  were layed in that category.

      Below is the category creation.

      Category Name ,Value.

      A - >8

      B - 6 and 7

      C - 4 and 5

      D -  <4

      E- 0

      Average value-sum(value)/count(months)

      how we will relate the average values in the above category.

      Sample data

      Empidvaluemonth
      A15Jan
      A28Jan
      A12Feb
      A28Feb
      A310Feb

      Final output:

       

      Categroyno of employess
      A2
      B0
      C1
      D0
      E0

      Can any one help me on this.

      Please provide me any suggestions.

       

       

      Thanks

      Kumar KVP