1 Reply Latest reply on Jul 27, 2017 5:57 PM by swaroop.gantela

    Count unique active organizations by month

    Sandra Ragues

      Hi all,

       

      I am trying to build a formula that will show me all active organizations by month.

      I basically have the following:

      - Organizations (example: AMEX)

      - Start date of the contract (Example: 10/06/2015)

      - End date of the contract (Example: 18 / 10/2018)

       

      I want this organization to appear on my report for all the months between the start and end date.

       

      Ideal Scenario:

                                    Organizations:

      January 2016               8

      February 2016             10

      March 2016                  9

      April 2016                    12

      etc                                etc

       

       

      Can someone help me please?

       

      Thank you!