Please check the attachment. The following explanation is what I want to achieve with the info from the client Meerkring Org.
From the first table, in the month of may (Maand) Mei in dutch we receive two invoices € 670,73 for Gas consumption and € 487,35 for electricity. As you can see from the Energy Type list box, the client has electra and gas connections. Now in the second table below I added the column Energy Type and the result is not what I expected.For Mei, the records are showing electra and gas twice for each of the amounts. But what I want is: The Maand Mei should still show two records as in the first table with € 670,73 associated to gas and € 487,35 associated to electra respectively.And from Jun through to Sep all those amounts are for gas but as you can see from the second table the same amounts are associated to both connections.
Please any help on how to resolved these issue will be truly appreciated.
