How To Make Qlik create entries on a table

[haiderlopez]

Hello All,

Thank you in advance for your help regarding my question and I apologize in advance if the question is a bit confusing but here I go... : 

I have a Financial report that has "Plug rows" to arrive to the totals on the Chart of accounts. In the Example Bellow Cells A2 to C5 Have the Data as I needed to look in the data model.; Row 4 needs to be a calculated input Qlik does ( do not want to manipulate data in excel) that makes the total sum of the assets = to 500. 

I hope my question makes sense. 

Thank you all again.

[Stoyan_Terziev]

Hi,

 I think you are looking for a measure with a set expression that should look something like this:

sum({<Account={1000}>} Actual) - sum({<Account={1001,1002}>} Actual)