Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
User | Count |
---|---|
127 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |