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.

[N1kh1l]

@Sumalini 

I do not think scripting is the option here. You should try Subtotal or % subtotal for this.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/3b7c99a7a7cd4a29bb1c5...

Hope this helps !!

Nikhil

[Sumalini]

@nikhil: Thanks for your reply. I think SubTotal function will fulfill my requirement.

But i couldn't see Subtotal function in calculation editor. Could you please help me here. I can see only Substring function, if i use ctrl+space.

Also in the functions, i can see GrandTotal function but not Subtotal. i'm i missing something? I also have Totals in my table, which is required for Subtotals as mentioned in documentation provided by SAP

Thanks,

Sumalini.