4 Replies Latest reply: Nov 17, 2016 6:26 AM by Risso Daniele RSS

    Count dimension in missing row

    Risso Daniele

      Hi all,

       

      i need to count a dimension (account) by month, but in some case i haven't this dimension in every month, for example because the account has not bought in a specific period

      Below the example

       

      AccountMonth
      AJan
      BFeb
      AMar
      CMar

       

      This the count that i would like to have

      Jan: 1

      Feb: 2

      Mar 3

       

      Thanks