7 Replies Latest reply: Aug 23, 2018 2:48 PM by Imran Syed RSS

    Summing Based on Selections for Multiple combinations of Dim values

    Imran Syed

      Hi Experts,

       

      I have a straight table with Territory Numbers and some Measures like Sum(unit sales),Sum(inventory Units).

       

      Now I need to sum the Total based on selection and simultaneously display entire Table.

       

       

      Ex:

       

      My  straight Table is :

       

       

      Header 1Header 2Header 3
      Territory NoSum(unit sales)Sum(inventory Units)
      110030
      220100
      3500200
      4300100
      5200100

       

       

      Expected Output:

       

      Header 1Header 2Header 3
      Territory NoSum(unit sales)Sum(inventory units)
      1 + 2120130
      3500200
      4+5500100

       

      How can we achieve this dynamically i.e up on selection it has to sum up and also display other rows

       

      Really appreciate your kind help

       

       

      Thanks

      Syed Imran