How to summarize attributes through a read-only report or a cda-report in Financial Management FM5.5

[Brian_Hansen]

Hi, I have a FM 5.5 installation, where we use a lot of attributes on f.ex. employee name, accounts etc. and I am looking for a way to summarize and show the sum for certain attributes in the reporting (read-only or CDA in Excel).

It is quite easy to limit the report til certain attributes, but you loose the sums in the other dimensions doing so.

I have attached a read-only report (where I am missing a sum for the acccount (1. dimension in rows).

I have tried using calculated members in Excel and cda, In Studio I have tried to use formulas, but no luck so far.

PS: Not certain about which board to choose (haven't found one specific for FM), so please help if you have the name of a better board for this question.

bye

Brian

[ElizabethKyria]

Hi Brian,

Please open a tech support track to assist with your question below, see link here - https://support.sas.com/en/technical-support/contact-sas.html

Kind regards

Liz

Elizabeth Kyriacou

Business Operation Specialist

Fraud & Security Intelligence Division

Tel: + 44 (0)1628 490859 ▪ Mobile: + +44 (774) 1241863▪ elizabeth.kyriacou@sas.com

SAS ▪ 7^th Floor 199 Bishopsgate ▪ London, EC2M 3TY

www.sas.com/fraudfinancialcrime

SAS® … THE POWER TO KNOW®