search

BITraining / SSRS_12132014_UserStory

11 stars 6 forks source link

Top 3 Best selling products under each category in USA #4

Open derekdai1978 opened 9 years ago

derekdai1978 commented 9 years ago

This report needs to show breakdowns by categories in a proper chart. Below this chart, use a container to demonstrate the Top 3 best selling products under each category. The necessary info for this table is Catogery/Productname/sales Amount/ Net Sold (Total) Quantity/. Each product name in the table should be linking with product detail report.

xlusa88 commented 9 years ago

When you talked about best selling products, what measurement do you use to decide best selling products, by Qty, margin or sales amount? Thanks!

derekdai1978 commented 9 years ago

Thought we will review the US by sequence from US1 to US9. So that is why I did not say here as it was mentioned in US2. This "best" is defined by Sales Amount

xlusa88 commented 9 years ago

I am not sure if you net revenue calculation is correct, Based on what I can tell, the sales amount is the result after the deduction of discountamount.

derekdai1978 commented 9 years ago

xlusa88,

Good catch. I updated my comments and the other US. It should be by "Sales Amount"

liangzz commented 9 years ago

Team: Group 1

Estimation: 16 Points

Primary developers: Sherry, Kevin

Interface with other issues: issue 3

Possible Solutions: This report will present information about the top 3 bestselling products under each category, one category per page. For each product, the report will display product category, name, sales amount and total sold quantity. The users will be able to drill down to view detailed product information by clicking on each product name.

Code reviewer: May

Tester: Ming

moonpond commented 9 years ago

This report needs to show breakdowns by categories in a proper chart.

  1. In this chart, do you need the sales amount for each category in the whole time frame?
  2. What type of chart do you want?
derekdai1978 commented 9 years ago

Hello MoonPond,

  1. In this chart, do you need the sales amount for each category in the whole time frame? Yes, I do.
  2. What type of chart do you want? I dont mind only if it shows data visually and properly. I am fine.
xlusa88 commented 9 years ago

Does sales amount need to include both physical store and online sales?

derekdai1978 commented 9 years ago

We are only looking at the table factsale.

xlusa88 commented 9 years ago

good. I was afraid that I had to union both factsale and factonlinesale. Thanks!

On Mon, Feb 2, 2015 at 11:32 PM, derekdai1978 notifications@github.com wrote:

We are only looking at factsale.

— Reply to this email directly or view it on GitHub https://github.com/BITraining/SSRS_12132014_UserStory/issues/4#issuecomment-72595330 .