Customise Report

ERPNext Reports
, , ,
1

Hello,

Can I create this type of report in Frappe version 15?

Screenshot from 2024-06-05 12-34-08
Screenshot from 2024-06-05 12-34-081209×87 9.21 KB

thanks!

2

You should be able to create a query report for this. It will be a bit complex with subquery and/or case statements. I’m not familiar with the source of this data so
I’d be guessing on the query.

Can you post the table(s) structure for the data source?

3

Hi @Anisha_Jain:

Dataframe, from Pandas library, lets you structure the data as your requirement, this kind of “pivot table”
Using it into query report would be a good approach.

Hope this helps.

4

Thanks @avc
Can you guide me on how to use the “pivot table”