Monthly Percentage Contribution in Analysis for Office

[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

[brigitta_eichenberger]

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

[Former Member]

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

[TammyPowlas]

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