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
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.
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.
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:
Don't forget to format the "% of Total" calculated measure to "Percentage":
Add comment