how to add a aggregation row in pivot table

[sutheeshsham]

hi i'm new to qlik sense,

i have a doubt in qlik sense

description             portfolio1           portfolio2            portfolio3             portfolio4         

expenses                   2000                           100                         500                           0

revenue                     1000                        1500                         2500                        100

Now, i want a third row that row should be divided by expenses/revenue with percentage

so if anyone knows please let me know what is the expression and where i can create the expression i mean field ASAP

[Mark_Little]

HI @sutheeshsham 

Depends on the data and the set analysis, how you would need to tackle it.

Is Expenses and Revenue field names or expression name?

[sutheeshsham]

which one is better field or expression

i think expression is better