How to do Transpose of report

Hello everyone, I want to transpose a table in the report i.e Heading column in row and values in the column. Usually, our ERPNext report shows Heading column in column and Values in a row. but I need to transpose this scenario.

Regards
Nivedha

Are there any possibilities to do this

Like this our report display
Department Count
IT 10
ECE 15

I need to transpose this report
Department IT ECE
Count 10 15

Regards
Nivedha

You want only one report like this or all reports throughout the ERPNext?

Hi @mangroliya, thanks for your reply. i want in only one report is it possible

Can any one tell me is there any possibility to achieve this transpose functionality?

Regards
Nivedha

Hi, you can create custom query report and transpose the row/Columns using SQL.

Second option is export the report in excel and use transpose function of excel.

Hi @mangroliya, thanks for your kind reply. Could you please give me an example SQL query for this function.

Regards
Nivedha

Hi,

Please check the mariadb documentation here: https://mariadb.com/kb/en/pivoting-in-mariadb/

Thanks,