Report with multiple key figs in same column

[former_member244687]

Hello All

I need to create a report with cost-element (in rows), fiscal period (in column). I have to create 4 reports with 4 keyfgures and all with same cost elements. The challenge is I wasnt them displayed not in the same row but in the column under each one.ao.png

Thanks

[MKreitlein]

Hello Raj,

this will be manual effort in including 4x the same query into an AO workbook, and always dispalying the one respective key figure.

What you showed cannot be created in the Query Designer for all 4.

You can do it only in AO with 4 included datasources, which can be the same query 4 times.

You need a VBA coding to dynamically fit the gap between it to not overlap.

BR, Martin

[former_member244687]

Thanks for your suggestion.