![]() You need to type the function %GrandTotal and select the Account and measure on which you need to calculate the Percentage share as shown below image. Click on three dot on column area and then click of “ Add Calculation“ You first need to make table with one dimension. In this example we will learn how you can apply percentage of share for one dimension in table view using %GrandTotal In SAP analytics cloud Percentage of total is really good function which can use in many view like table view and chart view.īelow are 3 examples explained for %GrandTotal() function Example #1: Percentage of share for one Dimension ![]() It will also work with the filters and automatically calculate grand total if you applied filters. You can also called as the share of percentage. %GrandTotal() function returns the (%) percentage of grand total for each values. Drag a second copy of Measure Values to Color on the Marks card.Overview: In this tutorial you will learn how you can calculate Percentage of total in SAP analytics cloud for specific account or Measures, explained with examples %Grand Total.Drag Measure Vales to Label on the Marks card.Drag a second copy of Measure Names to the Columns shelf.In the Filters dialog, check only all of the calculations created in steps 1-3 and click OK.Drag Measure Names to the Filters shelf.Remove Sales from both Label and Color.Remove YEAR(Order Date) from the Columns shelf.After that, change the Format of Cell range D5:D8 going through the steps shown above. SUM (C5:C8) Next, press ENTER to get the value of the Grand Total of Sales. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |