Multi Level Group By Result In a Single Row

[vijay@spinetechnologies]

Dear Team,

We want to achieve Multi-Level Groupby in a Single Row.

E.g. We have Created a Report using Five Columns
Grade, Branch, Department, Gender and Employee Code
We have kept Groupby for Grade, Branch, Department, Gender, and Count for Employee Code.

Please refer Attachment for the Expected result.
Kindly guide us to achieve the above result in Normal GroupBy and Pivot Group By.

[paramvir]

Apparently it's not feasible in pqgrid row grouping by the looks of it.

I may be able to find some alternative way if you could share the excel spreadsheet with expected result and a jsfiddle for pqgrid