Skip to Content

Is there a way where we can show values as percentage of total for a given measure?

Hi,

Consider I have a Table view as below.

Can someone suggest how can we get the Totals column as percentage of row totals as an additional column in the end?

Regards,

Kiran Shenvi

basic-tables.jpg (18.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 23 at 04:48 PM

    Hi Kiran,

    We now support %GrandTotal / GrandTotal functions in our calculated measures.

    See Mathematical Functions at: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/3b7c99a7a7cd4a29bb1c5132d91af341.html

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 30, 2017 at 05:29 PM

    In my opinion, you should be able to add a calculation for the specific Total defined in the grid for your account/measure. Then add a second calculation which uses the account/measure and is divided by the previously defined calculation of total. This method assumes a planning model is defined and would build the calculations in the Story, not by the account dimension. Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Peter,

      Thanks for your response. Looking at the configuration of environment at my client side.

      We don't have license to Planning model so our models are analytic in nature. Due to this I can't use the cell reference which you correctly advised.

      Also, we are required to use Live Connection to Hana Models built using Calculative Views. Over here again the limitation is that Calculation Editor doesn't support Aggregation Type for LIVE Connections. Due to this I am not able to implement the % formula. :-(

      Hope we getting some more functions in future releases.

      Regards,

      Kiran Shenvi

  • Jan 30, 2017 at 12:16 PM

    You might try something with formulas - see this YouTube https://www.youtube.com/watch?v=lI4LQM4Y4z4

    But a function like percentage of share may be nice to have, like Analysis Office - in which case I recommend submitting an idea to Idea Place at https://ideas.sap.com/ct/ct_list.bix?c=67F73D87-9FB4-4410-A955-352068451176 - I couldn't easily locate an existing idea.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 30, 2017 at 10:20 PM

    Hi Kiran,

    As Petar mentioned, you can use a calculated measure (create in account dimension) referencing a restricted measure (create in account dimension) in your story. This works for Planning and Analytical models.

    Here is how:

    • TOTAL_ALL2 is a restricted Measure with the following options (Constant Selection checked / City dimension with values of Brazil, Canada, India chosen ... note that my city dimension has a hierarchy and those are the parent members, in your case just select all the cities in your dimension).
    • % of Total is a Calculated measure referencing the Value account / the restricted measure defined above:

      Formula = [Value_XYZ] / [@TOTAL_ALL2]

    Don't forget to format the "% of Total" calculated measure to "Percentage":

    Add comment
    10|10000 characters needed characters exceeded