Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

I have a pivot table with results representing hours and dollar amounts. These values total to the 
right over a number of fields, and then appear in adjacent cells within a column:

I ned to sum the hours and values separately (the right hand totals columns may have been 
calculated differently, so I cannot just rely on the running cross-sum in the bottom right hand 
corner. In the right-hand totals, some columns from the pivot may have been excluded, for example, 
so my only source for the overall totals that I want is the right-hand column.

I could do this if I could access the row() value for individual elements, either in a sumif or by 
means of a filter, but I don't know whether this is possible, and in the test I tried, it did not 
work. Can anyone suggest a way to do this?

Peter West

"For my yoke is easy, and my burden is light."

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.