Create account receivable report by adding groupbycustomer group and import data in excel dynamicaly


In erpnext i downloaded account receivable report in excel and i created pivot table based on customer group.But my customer don’t want to download again and i want dynamic data has to be updated every day in that sheet pivot table and in excel sheet without doing manullay.