1 Reply Latest reply on Oct 28, 2013 8:26 AM by . Indumon

    How do I show multiple dimensions in adjacent columns instead of a heirarchy?

    Steve Duncan

      I need to be able to show summary data by year and territory, but not by territory year. What is I need 4 columns, one for each year, and then 4 more columns, one for each territory. In each would be sums of the row data.

       

      So the columns would be:

       

      2009|2010|2011|2012|east|west|north|south|

       

      The 2009 column would sum all territories in 2009, and the east column would sum all years for east.

       

      When I try to do this I get a column with a year, and then four territory columns under that year column - a hierarchy, normally very useful but not what I need in this instance.

       

      Anyone know how to do this?

       

      Thanks!