Ability to report on items purchased by Customers by Location

(0) Share

Report

Posted on by Lisa Sorensen_SGS

How would it be possible to either customize or create a new report that will generate a list of items purchased by Customers by Item Location. I reviewed the POWER BI Data Sets and don't see LOCATION as an option and I cannot figure out how to export an existing report to *.RDL to add additional fields. For example, I would like either have a Sales Line Items report by Location or a Items by Location by Customer report that will show each Item on an Invoice and where it was purchased from and by who.

Is this possible? Am I missing something on how to export other reports besides those in the Custom Report Layout window?

Categories:

Reports and Business Intelligence

I have the same question (0)

All responses (1)

Answers (0)

Lisa Sorensen_SGS on at

Like (0)

Report
Copy link

Link copied!

I think I have the preliminary steps figured out using the Report Layout Selection option and Custom Report Layouts using the help files but it does not look like it is possible to group by Location as I do not see it as an option in the *.RDL file Dataset.

I don't see an option to report Items by Customer By Location that can easily be created.

Was this reply helpful? Yes No