There is no way in Splunk today, that I'm aware of, to create two header rows, like you can in an Excel Pivot table. The closest you can get is to concatenate the two header labels into one field and create one row.
It looks like maybe you were trying to produce a report that has columns for each of two app names, for each of two statuses, but it is unclear what was supposed to be in the columns.
In any case, without the details of the events that are supposed to be turned into this format, we are not going to be able to be of much help.
I need out put with API_NAME as column label and APP_NAME as row label .
Under column API name there will be subcolumn with Different Status Code.Hope it clarifies you what I mean to ask.
Column [API_NAME(Subcolumn Status_Code like A/B/C .. )]
Row will be APP_NAME like X/Y/Z