6 Replies Latest reply: Nov 30, 2016 5:11 PM by Lech Miszkiewicz RSS

    Help to create table with measures coming from columns with same elements

    Sam Gamble

      Hi, not sure exactly how to ask this questions but I have the following data:

       

      Client

      Region

      Type A

      Region

      Type B

      Revenue
      AWestWest10
      BEastWest20
      CEastNorth30
      DEastEast40
      ESouthSouth50

       

      I would like the following report

       

      Region

      Revenue

      Type A

      Revenue

      Type B

      North030
      West1030
      East9040
      South5050

       

      Can you help?

       

      Thanks,
      Sam.