
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Adding a calculated row to a pivot table
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can reference specific rows, but you can reference specific dimension values and use the Total row for a custom calculation. See attached example
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can reference specific rows, but you can reference specific dimension values and use the Total row for a custom calculation. See attached example
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See these two blog posts:
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ok...got it now. I see what you meant by using the totals row.
Thanks so much for your help!!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How would I add other calculated rows? So, that I have more than 1 calculated row.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
