3 Replies Latest reply on Oct 28, 2014 5:46 AM by Tableau kumar

    Summing up  a column of count() and display




      I have report which looks like this:




      i want to display some like this:




      Oct 2014100252550
      Nov 201480204020




      Basically on dragging CNT(members) they are not getting added up. it shows individual count then group by 0,1,2,...


      but i want to sum (cnt(members)) then display the corrsponding group by 0,1,2,.... in a single line.



      equivalent sql is :


      select MY,sum(x)  from


      select MY,-- datepart

      count(members)over(partition by MY order by MY desc) as x from t


      group by y.MY