Epic Progress Report

I have Epics with following workflow: New- Defined- In Dev- In Test- Approved

I have User Stories in the following workflow: New- Defined- In Dev- In Test- Approved

I have following scenario: I have 2 Epics:

Epic A- (In Dev State) has 4 User Stories. 2 of the User Stories are at Approved and 2 at Defined state. Approved User Stories are 10 points combined (5 each) and Defined user Stories are 8 points combined (5 & 3 each).

Epic B (In Test State) has 2 User Stories. 1 of User Story is In Test & 1 In Approved state. User story in test is 5 points and Approved state story point is 13 points

Note that anything at Approved state is Done & any other state such as New, defined, In dev, in test are In Progress

In the example above:

Epic A is 56% (10/18) Done & 44% (8/10) In Progress

Epic B is 72 % (13/18) Done & 28% (5/18) In Progress

I am trying to see a view of my epics in the following way under 1 view for the executive team:

Epic Name Epic % of Done Epic % of in Progress Epic Done Story Points Epic In Progress Story Points
Epic A 56% 44% 10 8
Epic B 72% 28% 13 5