G
Gio Bacareza
I have a 4 column table (Column A,B,C and D)as my source data. D contains
numbers. I do a pivot table report. I layout A,B and C (in this order with
subtotals off) as row fields and D as datafield as sum. I reenter D into the
data area and do a custom calculation by specifying Show data as:
"Difference From", with Base field = B and Base item = (previous).
The result i wanted would have a sum of all B items with common A's as well
as the difference between consecutive items.
The custom calculation behaves inconsistently: for some items, it shows the
difference for some it doesn't.
It works however when i turn on subtotals for field B, which i prefer not to
do because it makes it look messy. It also works when i remove field C,
which i dont want to do because i need to see field C.
Any solutions?
thanks. /Gio
numbers. I do a pivot table report. I layout A,B and C (in this order with
subtotals off) as row fields and D as datafield as sum. I reenter D into the
data area and do a custom calculation by specifying Show data as:
"Difference From", with Base field = B and Base item = (previous).
The result i wanted would have a sum of all B items with common A's as well
as the difference between consecutive items.
The custom calculation behaves inconsistently: for some items, it shows the
difference for some it doesn't.
It works however when i turn on subtotals for field B, which i prefer not to
do because it makes it look messy. It also works when i remove field C,
which i dont want to do because i need to see field C.
Any solutions?
thanks. /Gio