I want to create a summary table based on product of all OPEN opportunities. An Opportunity can have multiple quotes associated with it and each quote can have multiple lines.
The value of the Opportunity is to be calculated from the latest quote (derived from QUO_CreateDate)
How can I achieve this? I’ve attached some dummy data.
I’ve got the latest quote value when in the context of OP_Id but can’t work out how to translate this to ProductName context.
Also the totalsDummy Data File 2.pbix (153.8 KB) for the table on Latest Quote doesn’t total the column