How to create a nested table

[shirleyc40]

Hi, I'm trying to replicate a table like this:

I'm not sure if it is possible. 

[QFabian]

Hi @shirleyc40 , you can start with this, and then add more fields and calculations, you can even  out spaces as indentation, but lets start with the first part :

Data:
LOad * INLINE [
Apps Submitted, Status
100, Pending Review
1000, Pending Decision
1300,Pending Decision
89, Pending Decision
200, Pending Manager
37, Pending Manager
480, Pending Applicant
];

Nested:
Load
Status as StatusNested,
sum([Apps Submitted]) as TotalAppsSubmitted
Resident Data
Where
Status = 'Pending Review'
Group By
Status;

Load
Status as StatusNested,
sum([Apps Submitted]) as TotalAppsSubmitted
Resident Data
Where
Status = 'Pending Decision'
Group By
Status;

Load
'Total in Review' as StatusNested,
sum(TotalAppsSubmitted) as TotalAppsSubmitted
Resident Nested;

Load
Status as StatusNested,
sum([Apps Submitted]) as TotalAppsSubmitted
Resident Data
Where
Status = 'Pending Manager'
Group By
Status;

Load
Status as StatusNested,
sum([Apps Submitted]) as TotalAppsSubmitted
Resident Data
Where
Status = 'Pending Applicant'
Group By
Status;

Load
'Total Apps' as StatusNested,
sum(TotalAppsSubmitted) as TotalAppsSubmitted
Resident Nested
Where
StatusNested = 'Pending Manager' or StatusNested = 'Pending Applicant';