Advanced pack report help

[dreginald]

Can anyone help me on how to do "Grouping grid report with non-aggregated columns".

[olof]

Thanks Yuri!

[yuri]

If you group by Account then it will be possible to make such a report after EspoCRM 5.6.0 released. Planned release date is not very soon.

[olof]

Thanks Yurikun!

[yuri]

Hi,

It's not possible to add foreign columns in grid report at this moment. I will look into this problem.

[Maximus]

Hello, could you add attachments with your report configs and report as well?

[olof]

Each of our accounts has a custom field with a £ value for target revenue.
I am looking to create a report that has two columns.
1) opportunity value won this year
2) target revenue

So that these can be compared.

I have started creating the report as a grid of opportunities and have the opportunity values. I seem to be able to group by account.target_revenue but can't get this value to display in the grid? Any ideas? Seems like a basic standard report..