Skip to main content
Hello Smart People!

 

I got a report request today that I'm having trouble scoping out.  The report is generally on Accounts object and I have roll up fields for all of the metirics.  Except, the client want to add projections at the beginning of the year for each Account, by month.  So, the would enter the predictions for April 2020, May 2020, ect... for each metric that I currently have on the Account.  

 

My question is, how should I handle these predictions given the screen shot they gave me of how they want this report to look?  My first thought is to make a custom object (master detail) to Accounts called "Predictions."   But even if I do that, I'm not sure i can ever get this layout to exactly match what they are looking for.  

 

Someone help me out on this one, please!  Is this even possible? See screen shot of what they are looking for. Report from hell

 

So, going from the left hand side, it's grouped by Account type, then Account name which I had to scratch out.  Each one of those fields below are roll ups on the Account page.  Ok that part is easy.  

 

If we move right, they want each one of those fields sorted by year.  That's OK too, I can roll up for each year 2018 and 2019.  Cool.   For lift percentage, that should be easy with a report formula.  

 

Then this is where I'm lost.  How can I show these predections for each month next to these other fields?  I can't right?  They have the columns grouped by the prediction month.  It just doesn't make sense.  

 

Any help appreciated!  Thanks in advance. 

 

 
7 Antworten