Show the overall price of cost of servers per model

[paulmagaling]

We have one report where we need to show the servers with their specific overall price per model. So far, with exploring the Platform Analytics, I still can't sum the cost for each model group. A colleague of mine suggested that I should try indicator scorecard and formula indicator; but, as I worked with formula indicator, it doesn't show the records as required for the report.

Is there any other solution or idea to sum the cost for each model without the need of creating a custom field?

Thanks,

Paul

[Mark Manders · Accepted solution]

Have you tried a pivot table with a sum?

Set your rows to model (group), and your metric to cost (SUM)

[Mark Manders]

and by adding rows, you can create your 'group by' (use 'show pivot expanded' option under 'presentation' as collapsed/not collapsed)