Dynamically insert a calculate row in table

[#1]

Hi Guys,

I have a table with following structure in qlikview. (This is the table that I am creating from my source data at front end )

Head                 Budget

Revenue             1000

Material              1500

I want to add third row in my table Revenue% as Revenue/Material. How to add this row dynamically in my table.

Kindly help me Its little bit urgent

Tribhuwan

[preminqlik]

hi there, if i understood,

take dimension as calculated as given below :

ValueList('$(=concat(if(aggr(sum(Budget),Head),Head),chr(39)&','&chr(39)))','R/M')

expression:

sum(if(ValueList('$(=concat(if(aggr(sum(Budget),Head),Head),chr(39)&','&chr(39)))','R/M')=Head,Budget,$(=sum({<Head={'Revenue'}>}Budget)/sum({<Head={'Material'}>}Budget))))

once try above one let me know

@premhas

[preminqlik]

here is the another way