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

    Summing up  a column of count() and display

    vijaykumar.h

      Hello,

       

      I have report which looks like this:

       

      1.PNG

       

      i want to display some like this:

       

       

       

      MYMembers012
      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

      )y

      group by y.MY