Multi level Pivot table report

[MercBuilding]

Hi,

   I have a table which has different level of approvers and there are 6 fields of different approvers. I want to create a single report which contains all these fields and for each column it should show how many records have empty value.

For ex:

Suppose the fields are Approver 1, Approver 2, Approver 3, Approver 4.

All these fields should appear on single report may be as a bar /pivot table and when we click on that it should show the records which doesnt have Approver details filled( basically empty Approver details).

Can anyone let me know if this possible to achieve.

Thanks!

[Dr Atul G- LNG]

Hi @MercBuilding 

Create report = Type

[Dr Atul G- LNG]

Hi @MercBuilding 

[MercBuilding]

Hi Atul,

   Is there any other way to do it? i think there is limitation of number of columns we can choose. Also i want to see the result under each column not as combined ones as it is shown in the image. Example Business Impact - 2, Assignment group- 2.

Thanks!