2 Replies Latest reply on Sep 1, 2017 7:26 AM by Oguz Kiranlar

    How to group the measures in a simple excel file

    Oguz Kiranlar

      Hello,

       

      I have a excel data set, looks like this. I have companies. The first 3 column are the customer segment of the company and the last 3 are the services of the company. For instance Company EnerNOC serves Large and Medium customers and its service is Turnkey DR service.

       

      Tabl-.PNG

       

      I would like to have a visual which looks like this. The X axis is customer segment, the Y axis the service. For instance, If company EnerNOC serves Large costumers and  the service is Turnkey DR service, it should aggregate in the crosssection of these too. And if there is another company which does the same thing, it would add on to the same spot. Please help me. I have been trying for too long.

      exp.PNG