Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to make a chart that when i choose invoce it will present all the sales fore that customer as if i choose customer and not invoc
i have trysd set that ignores invoice but it doesnt work
Hi ester_pr,
Not quite sure of your problem: is your chart currently displaying customer on one axis, and invoice value on another? Do you then want to display customers and sales (changing the expression: invoice value to sales value)?
or
is your chart by "Invoice Number" (and sales/invoices) and you want the dimension to change from "Invoice Number" to "Customer" ?
Can you post an example QV doc of your problem, and then I can have a play...?
Kind regards,
Rich
My chart displays, sum(sales) By month, the user is choosing in a list box -invoice number ,the chart sould display
all sales for the customer of that invoice in that month and prior
Kind regards,
Ester
Perhaps this?
sum({<Invoice=,Customer=P()>} Sales)
Hi,
it sums all the Customers, I need only the Customer of the invoice
regards,
Ester
My mistake it does work
Thank you!!
Ester