SIMPLE VERTICAL ANALYSIS ON SAC STORY TABLE

[former_member287402]

Hi experts,

How can I perform a simple analysis like this (NET INCOME SHARE) on SAP Analytics Cloud Story Table?

Regards,

Rogerio Correa Jr

[former_member287402]

Hi Venkat,

I've performed that step you sent on first link, but in that example the objective is to analyse just one measure (filtering Sales Revenue) and open data by another dimension rather than Account, for example "Country". In my case, I still need to analyse data by "Account" because it's a Income Statement and I can't filter just "Sales" on my table.

About the second link, those formulas are very useful but I can't edit them to reference a specific row (Sales Revenue) for example.

Regards,

Rogerio

[menegasso]

Hi Rogerio,

Were you able to figure out how to make the vertical analysis in SAC? I have a similar requirement, to calculate the % of an account of the P&L comparing to the Gross Revenue.

Thanks,

Andre

[former_member135666]

Hi André,

I'm with the same problem yet. My users are exporting that information to Excel and calculating it by formulas, unfortunately.

This is a very common analysis of incoming statement, including analysis for open capital companies. We don't understand why SAP doesn't enable this.

Regards,

Rogério

[venkateswaran_k]

Hi

Please refer to this link. this may gives you the lead.

https://www.sapanalytics.cloud/creating-cross-calculations-in-a-table/

Or

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/b6371b0fac6e4919a34d44651...

Regards,

Venkat