drawing a bar chart which it dimension include 5 main groups and two maximum of the last group

[Mkh13646]

Hi all,  I have a dataset like below picture which includes some account and their groups, periods, and their amounts and I would like to draw a bar chart which it's dimension include the sum of my 3 main account group in each year plus two maximum sums of account in the third group, then drill down to company, is there any way to extract the two maximum account from the third group and draw them beside the three main group?

My chart should include  sums of amounts of group A, B and C for each year, and sums of the maximum amount of two accounts in group C

[Brett_Bleess]

Best I have as a point in the possible right direction is the following, not sure if it will work or not, but pretty sure that is where you need to head with this one.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Server/Content/QV_Server/QlikView-Server/Q...

Here is the base URL to the Design Blog area if you want to do some further searching on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett