Help with SPM Reporting

Tracey Wilmot
Tera Contributor

‎10-18-2023 07:02 AM

Hi all,

I'm trying to create a bar report displaying our Top 10 Projects based on Approved Budget.

I've managed to create this report but now need to add additional bar columns for Actual spend and Expected final cost of the same Top 10 Projects.

So for each of the Top 10 Projects, there will be three bar columns:

1. Approved budget

2. Actual spend

3. Expected final cost

Any help would be greatly appreciated.  I've attached a screenshot of what I've been able to achieve so far.  I'm using the pm_project table.

TraceyWilmot_0-1697637690654.png

 

0 Helpfuls
  • 616 Views
6 REPLIES 6

Prashant Moily
Mega Sage
In response to Tracey Wilmot

‎10-18-2023 10:38 AM

Hi @Tracey Wilmot 

 

Try using Stackby/ additional Group by and see if it meets the requirement.

 

PrashantMoily_0-1697650254679.png

 

Regards

Prashant 

Tracey Wilmot
Tera Contributor
In response to Prashant Moily

‎10-19-2023 03:59 AM

Thanks Prashant, I can't get it to work but I've marked your responses as helpful as I appreciate your help 🙂

 

0 Helpfuls