+ Start a Discussion
HaralambyHaralamby 

Matrix Reporting with Multiple Columns (at a summary level)

My question specifically is about Matrix Reporting and the limitation of having only two columns to summarize.  To reiterate, I am looking to be able to run a matrix report (at a summary level) that has multiple columns that describe it such as: Region, Brand, Product Class, Industry, and so on…. And at the same time summarize revenue schedules by month.

 It would look something like this:   

 

Multiple Descriptive ColumnsProduct 1 Revenue ScehduleProduct 2 Revenue ScehduleProduct 3 Revenue ScehduleTotal Revenue Schedule
Opp.AccountRegionBrandClassSub ClassJanFeb MarchJanFebMarchJanFebMarchJanFebMarch
Opoprtunity 1xxxxx$$$$$$$$$$$$
Opoprtunity 2xxxxx$$$$$$$$$$$$
Opoprtunity 3xxxxx$$$$$$$$$$$$

Is there a workaround for this? 

The only other thing that I can think of is creating dynamic name fields.  Meaning custom Fields that the label itself is a date (not text) that changes and that I can use when creating a custom formula.  Is there a way to do that?

 

Thanks!!