Sorting of excel data with multiple groupings

[dschauhan11]

Hi All,

I am new to the forum and looking for the solution sorting the data which has multiple level of groupings. I have tried to locate the solution on the web with no success, so really not sure whether a solution is available for the same.

I have spreadsheet with big data which contains the multiple level of groupings and now I want to sort this data from largest to smallest values of FY15. And I want to perform sorting at all level of groupings starting from level 4 to level 2. The raw data is something like "Base sheet" of attached spreadsheet and the desired outcome should be something like "Solution" tab of the sheet.

Is there any way I can perform this task without any manual efforts?

[Glenn Kennedy]

You attached the wrong sheet. No solution Tab!!!

[dschauhan11]

Sorry. Updated now

[Manikandan Arumugam]

Given sample file looks difficult to com to an solution. It will be helpful if u give actual file and required output format.