T
Tim Miller
I'm pulling invoice line data from a SQL db into a pivot table.
I want to show a distinct number of invoices, not number of invoice lines.
Is there any clever way to do this through those custom summaries or
something like that?
I know that I could add a field to the SQL View that had a value of 1 of
first line, and zero for subsequent lines.. and then I could summarize that
field. Or some similar method. The problem is that depending on how the
user manipulates the pivot table, they could potentially filter out some of
the lines of an invoice (making this method inaccurate).
Thanks for any direction!
Tim
I want to show a distinct number of invoices, not number of invoice lines.
Is there any clever way to do this through those custom summaries or
something like that?
I know that I could add a field to the SQL View that had a value of 1 of
first line, and zero for subsequent lines.. and then I could summarize that
field. Or some similar method. The problem is that depending on how the
user manipulates the pivot table, they could potentially filter out some of
the lines of an invoice (making this method inaccurate).
Thanks for any direction!
Tim