You need to sign in to do that
Don't have an account?
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 Columns | Product 1 Revenue Scehdule | Product 2 Revenue Scehdule | Product 3 Revenue Scehdule | Total Revenue Schedule | |||||||||||||
Opp. | Account | Region | Brand | Class | Sub Class | Jan | Feb | March | Jan | Feb | March | Jan | Feb | March | Jan | Feb | March |
Opoprtunity 1 | x | x | x | x | x | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
Opoprtunity 2 | x | x | x | x | x | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
Opoprtunity 3 | x | x | x | x | x | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
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!!