Skip to Content
0

Monthly Percentage Contribution in Analysis for Office

Dec 26, 2017 at 04:43 PM

74

avatar image
Former Member

Hi,

I am trying to use percentage contribution in analysis for office. But instead of showing % based on monthly total (month is in the header column), it shows % based on overall totals. If sales are $120 for the whole year ($10/month), I would like $6 in January to represent 60% of January and not 5% of the whole year. How can I achieve that using AO 2.5 and HANA studio.

Thanks

Patrick

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Tammy Powlas
Dec 26, 2017 at 05:03 PM
0

Hi - have you tried using Excel formulas? Are you on the latest release of 2.5? Maybe also try using 2.6?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 26, 2017 at 05:11 PM
0

Thank you Tammy. It works with Excel formulas but I am trying to find something more robust.

Share
10 |10000 characters needed characters left characters exceeded
Brigitta Eichenberger Jan 25 at 01:21 PM
0

We are struggling with the same issue does someone have an idea?

Share
10 |10000 characters needed characters left characters exceeded