13 Replies Latest reply: Aug 20, 2018 10:24 AM by Imran Syed RSS

    Summing based on Selections

    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

       

       

      Expected Output:

       

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

       

      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