2 Replies Latest reply: Oct 16, 2018 2:36 PM by Zhandos Shotan RSS

    Set Analysis previous three month

    Cecilia Cannito

      Hi, Everybody,

       

      i need to calculate a number of suppliers of previous three month

      I have to build a table with three columsn:

      First Column: city of Italy (FORN_UBICAZIONE_COMUNE)

      Second Column: number of suppliers (FORN_COD)

      Third Column: number of suppliers of previous three month (

      =count({<FORN_DATA_INIZIO={"=$(=MonthStart(AddMonths(Max(FORN_DATA_INIZIO),-3)))"}>}FORN_COD)

      but this code desn't work.

       

      Can you help me?

      Thanks a lot,

      Lia