Hi All,
Is it possible to use an aggregated model in a Table Drawer that uses another aggregate model for Context?
The scenario is that we have opportunities that can be raised against multiple Site accounts so we want to display a summary of the opportunity product quantities and total prices by Site account. It’s easy enough to product the tables but we want to be able to display the result using a drawer so that you see a list of Site Accounts and then if you expend a Site Account drawer it will show you the summarised opportunity data for that Site.
I have attached an image of the closest I can get but if I set the context of the drawer so that it matches on the ‘Site account idr id’ it doesn’t display any results.
Many thanks,
Rob