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:




      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?