Adding a calculated row to a pivot table

[#1]

I have a pivot table that i would like to add an extra row with a calculation. I need to divide 2 specific rows in the table to get the calculation. Any ideas on how to do this? Nothing I have tried seems to work. First, any calculated expressions always appear as columns. Second, I can't seem to figure out how to reference specific rows for the calculation.

I attached an image.

Thanks in advance

[Gysbert_Wassenaar · Accepted solution]

You can reference specific rows, but you can reference specific dimension values and use the Total row for a custom calculation. See attached example

[#3]

Thanks...i'm not sure I understand how Dimensionality works. Can you give an explanation of what's going on in your calculation?

Also, how do you make the expression "Calculated Row" appear as a row instead of a column?

I get zero for my calculations...looks like dimensionality is always one in my table.

[Gysbert_Wassenaar]

See these two blog posts:

• Qlikview Subtotaling Customization
• Qlikview Subtotaling Customization: Part 2

[#5]

ok...got it now. I see what you meant by using the totals row.

Thanks so much for your help!!!

[#6]

How would I add other calculated rows? So, that I have more than 1 calculated row.

[#7]

I tried it with a calculated dimension and it works but I can't get the total to work across the rows. The calculation is correct for each row but the with show partial totals turned on, it is blank for each row. I used aggr with the date as the dimension.