Skip to Content
avatar image
Former Member

Monthly Percentage Contribution in Analysis for Office

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 26, 2017 at 05:03 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 26, 2017 at 05:11 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 25 at 01:21 PM

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

    Add comment
    10|10000 characters needed characters exceeded