I have multi company enabled, and I have few branches under my main company. 

In sales dashboard, I can put a filter to manipulate the data shown to include one or more of the branches-companies. 

but in finance dashboards, I guess its not using pivot tables, but rather pulls data via in cell formulas like =-ODOO.BALANCE(ODOO.ACCOUNT.GROUP("income"),B$30). it only pulls date from the active company, not from its children (sup-companies) 

Is there any way I can change the formula to pull all companies data?  thank you.