chart that present different from the selection

[ester_pr]

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

[#2]

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

[ester_pr]

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

[johnw · Accepted solution]

Perhaps this?

sum({<Invoice=,Customer=P()>} Sales)

[ester_pr]

Hi,

it sums all the Customers, I need only the Customer of the invoice

regards,

Ester

[ester_pr]

My mistake it does work

Thank you!!

Ester