Calculate Totals manually in SAP Analytics Cloud

[Sumalini]

Hi All,

Can you please suggest me on how to calculate the below Total_Count value using script. 

Once i get the total_count value, i have to calculate the  % values for each code. So what is the % of incidents for that code with total incidents.Hence i cannot use Show Totals option for that Dimension.

Thanks in advance.

	Dimension2	Code X	Code Y	Code Z
	Measures	Count	Count	Count	Total_Count
Dimension1	Country Dimension
Code A		2	1	-	3
	US	1	-	-
	CANDA	1	1
	CHINA
Code B			4	3	7
	US			2
	CANDA		2	1
	CHINA		2
Code C		1			1
	US
	CANDA	1
	CHINA

[Yogeshwar_M]

Hi @Sumalini ,

You can find subtotal function in model level only.

In model calculation 

Subtotal

Subtotal%

In story you can also do it but you need to create restricted measure and then calculate subtotal

Kindly upvote and like if you find it useful.

Thanks

[Sumalini]

@Yogeshwar : Could you please let me know on how create restricted measure and then calculate subtotal, i tried several ways but couldn't find a way

[Wilton]

I could not find the subtotal function either, only the grandtotal function is available.