K
Kanga
Hi,
I have a table containing invoice lines, country and amounts.
I'm building a pivot chart query based on that table to show me a summary of
the invoice amount by country. I also want to add the number of distinct
invoices that every country bucket contains. However I only see an option to
include "count" of invoices and not "count distinct" like in excel.
Help?
Thanks a lot,
Géraldine
I have a table containing invoice lines, country and amounts.
I'm building a pivot chart query based on that table to show me a summary of
the invoice amount by country. I also want to add the number of distinct
invoices that every country bucket contains. However I only see an option to
include "count" of invoices and not "count distinct" like in excel.
Help?
Thanks a lot,
Géraldine