How to do Transpose of report

ERPNext Reports
1

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

2

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

3

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

4

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

5

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

Regards
Nivedha

6

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.

7

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

Regards
Nivedha

8

Hi,

Please check the mariadb documentation here: Pivoting in MariaDB - MariaDB Knowledge Base

Thanks,