6 Replies Latest reply: Oct 10, 2012 11:54 AM by Balraj Prabhu RSS

    Straight table, 'switch' axes

    Michiel van de Goor

      Hi,

      I have a table like this:

      WeekRevenueCosts
      110090
      211095
      39096

       

      But I would like to have this:

      Keyfigure123
      Revenue10011090
      Costs909596

       

      So it will be a straight table with the axes switched because I don't have the fields to create a pivot. All keyfigures are independend columns in my data and I want to keep it like that to make calculations (Revenue / Costs etc.).

       

      How I can switch the axes?

       

       

      Thanks for your help