Graph from Search option for particular product

[kritpatel]

Gentleman, i have row level data in Excel and need sales value of product e.g 9000XL from a database and that query needs to apply for interactive change on report level graph.

InvoiceNo  InvoiceDate    ItemDesc Qty  AddChrgUnits UOM UnitPrice Discount LineTotal                                                                      39903146  2017-10-24     Deep ultra power 9000 XL 2 11 DAY(S) 1,232.40 - 27,112.80

39903146 2017-10-24      Deep ultra power 9500 XL 2 11 DAY(S) 1,232.40 - 27,112.80

39903146 2017-10-24      exp power exx 9500 XL 2 11 DAY(S) 195.00 - 4,290.00

39903146 2017-10-24      Ultra power exx 9100 XL 2 11 DAY(S) 195.00 - 4,290.00

39903146 2017-10-24      exx 9500XL 2 11 DAY(S) 195.00 - 4,290.00

39903146 2017-10-24      9500 XL 2 11 DAY(S) 1,232.40 - 27,112.80

[v-piga-msft]

Hi @kritpatel,

I 'm a little confused about your problem.

Do you want to get the specific data from Datebase by query?

Or do you want to get the inpfomation of particular product in a graph by search the product?

Could you describe your scenario in more details? I would appreciate it if you could provide the data sample more clear.

Best Regards,

Cherry