G1 is the right percent of the total, but i want that A-BA inside the G1 be the percent of how it represents of G1, not the percent of the total. Like 13% would be something like 60% of the 22%. How do i do it? I tried to create some calculated field but didnt work.
Hi @mathewsmelo ,
Can you check with the below calculation.
For better understanding you can go through the below link.
Thanks & Regards
Biswajit Dash
1 Like
Hello, i tried this, but did not work, the percent still not going to 100 in both group and sub group.
Thanks,
Hi Mathews @mathewsmelo ,
You can use the table calculation feature for this. You can’t get the combination in same column but can do two percent of total table calcs to get what you are looking for. See screen shot below.
The first table calc has the calculate as option set to Table down and second has it set to Group down. Hope this helps.
I’m marking this as solution here. Please let us know if you have further questions.
Regards,
Arun Santhosh
Pr QuickSight SA
1 Like