2 weeks ago - last edited 2 weeks ago
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 |
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I do not think scripting is the option here. You should try Subtotal or % subtotal for this.
Hope this helps !!
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.
User | Count |
---|---|
56 | |
10 | |
8 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.