Overview: In this tutorial we will learn and understand the GrandTotal function in SAP analytics cloud and how you can use GrandTotal.
GrandTotal() Function
GrandTotal() function return the aggregated values of the measure and account. You can also called it as SUM function but the keyword we used to calculate is GrandTotal in SAP analytics cloud. If you will search SUM function in calculated field area you will not able to find our SUM. So GrandTotal will be available to use as sum.
Syntax:
GrandTotal(Measure/column name)
Lets understand with example
Example: GrandTotal for Revenue
If you will apply Grandtotal for any column and you will drag that column in table view then that will show the total values in each rows as shown below image
Then question is why we need this formula and where we can use it, so answer is we can use Grandtotal within another formula to calculate some other values, one example the percentage share, we can divide each row values with Grandtotal to show the percentage values