6 Replies Latest reply: Oct 22, 2015 6:51 AM by Evgeny Stuchalkin RSS

    calculated dimension for amount of deals per contact

    Evgeny Stuchalkin

      Hi every one! I have two tables: Contacts and Deals, that connected by kei field "Contact ID".

       

      I can calculate amount of deals for each contact: 0, 1, 2 e.t.c

       

      What i need to do for using amount of deals as dimension?

       

       

            | Total contacts| 2 sales | 1 sale | 0 sales

      sep |      200          |     100   |   50    | 100

      oct  |      300          |     50    |    100  | 150

       

       

      Details in this video: