first of all, there are no macros on Qlik Sense, instead of macros you can the extension. for extensions look at :Qlik Branch
in banking sector you see very often (Profit and Loss, balance sheet), in this you can use for creating of these financial dashboard the normal pivot table. but all depends on your bussiness environment. Give an example of your expected output.