Dashboard Format Question (summarizing)

Question

I am messing around a bit here looking to create a dashboard to summarize some specific information. I am starting with a report.&nbsp;My fields are as follows: Market Type (subject), Probability (in percent 0,1, 10,20,70,90), Expected Revenue (in dollars), Status (open or closed), Region (for filtering later)Example Data:&nbsp; &nbsp;Football, 10%, $1000, Open, EastBaseball, 90%, $500, Open, WestFootball, 30%, $700, Open, SouthSoccer,&nbsp; &nbsp; 10%, $600, Open, South&nbsp;I am trying to summarize this in such a way that it looks like the following:Market Type&nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;70&nbsp; &nbsp; &nbsp; &nbsp; 90&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Grand TotalFootball&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $1000&nbsp; &nbsp; $700&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $1700Baseball&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $500Soccer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $600&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$600Grand Totals&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $1600&nbsp; &nbsp; $700&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$500&nbsp;I have been messing around a bit with both a TABLE and SUMMARY report and I am getting mixed results.&nbsp; &nbsp;What would be the best way to approach this? I have a feeling i'm overthinking this a bit.&nbsp;Any suggestions would be appreciated.&nbsp;&nbsp;&nbsp;

markshnier__you · Answer

A simple summary report should work.&nbsp; Summarize that value field with Rows by Market Type and column groupings by that % field.

Forum Discussion

Dashboard Format Question (summarizing)

Related Content

Chart Question

Form Rule Question

Jinja Question: Adding business days to today

Rich-text formula button on dashboard

Questions & Checklist setup