4 Replies Latest reply: Dec 21, 2010 11:10 AM by Joe Kirwan RSS

    Crosstab

       

      Hello All,

      I'm looking for the structure below on my sheet (crosstab)

      XCalendar Year 2009Calendar Year 2010
      A$30$40
      B$20$48
      C$5$10

      My raw data structure is like

       

      Calendar_YearXRev
      2009A5
      2009B10.053
      2011A5
      2011C7
      2012A8
      2012B40


      so if I use a straight table with SUM for Rev I 'm not able to get cross tab structure as above, please suggest how that can be achieved aprt from pivot as pivot will also show me but in vertical direction.

      is it possible from object properties only or do I need to change the raw data structure using transformation. if I can do from object property that be great as change in structure could loss my other elements in dashboard.

       

      Thanks..

        • Crosstab
          Deepak Kurup

          Hi,

          Once you have done with SUm(Rev), pull the year dimension to the top of the Rev.

          Drag it to the top and you will get your data in cross format.

          • Crosstab
            Joe Kirwan

            Hi

            Pivot table can be used to show in desired format:

            In Dimensions: X and Calendar Year

            In Sort - make sure X is first dimension.

            In presentation - show partial sum on X

            This will give you a pivot table in format piv1 per attached.

            Click on + to display Calendar Year (piv 1a)

            Drag Calendar Year to top - gives desired result in piv 2 attached