I just wanted to know the Subtotal of the Top 10 Accounts Vs the total of all the accounts.
I don't wanted to add the subtotal for each account. On line for the total top 10 and the overall total line.
Please let me know if it doesn't make sense.
Please let me know if anybody know the tricks.
This can be achieved with a correctly scoped window_sum and either a second window_sum or total scoped to the table for the total