Hello,
I need to run a report for work to show me revenue and qty sold in each categories, and sub-categories.
Unfortunately my ERP system doesn't break the category down so I have had to do it manually in Excel, this is how it's shown on our system - "Catheters > Gloves > Powder Free Gloves",I split this using Text to Column (I'm ignoring the Grandchild Category).
I tried using the filter option, yes it gives me the data I need but I have no idea to group it. Reason being I have 5407 Rows, 26 Categories and 166 Sub-Categories.
I can't without manually having to create a new report and copy paste information i.e.
for Category -
[TABLE="width: 500"]
<tbody>[TR]
[TD]Category[/TD]
[TD]Qty Sold[/TD]
[TD]Amount.[/TD]
[/TR]
[TR]
[TD]Assistive Furniture[/TD]
[TD]2167[/TD]
[TD]342043.83[/TD]
[/TR]
</tbody>[/TABLE]
&
for Sub-Category
[TABLE="width: 500"]
<tbody>[TR]
[TD]Catergory[/TD]
[TD]Sub-Category[/TD]
[TD]Qty Sold[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Assistive Furniture[/TD]
[TD]Bed & Accessories[/TD]
[TD]400[/TD]
[TD]61618.07[/TD]
[/TR]
</tbody>[/TABLE]
Is there a way to do quickly or automatically? It would take me several hours to do this especially with 166 Sub-Categories.
Thank
I need to run a report for work to show me revenue and qty sold in each categories, and sub-categories.
Unfortunately my ERP system doesn't break the category down so I have had to do it manually in Excel, this is how it's shown on our system - "Catheters > Gloves > Powder Free Gloves",I split this using Text to Column (I'm ignoring the Grandchild Category).
I tried using the filter option, yes it gives me the data I need but I have no idea to group it. Reason being I have 5407 Rows, 26 Categories and 166 Sub-Categories.
I can't without manually having to create a new report and copy paste information i.e.
for Category -
[TABLE="width: 500"]
<tbody>[TR]
[TD]Category[/TD]
[TD]Qty Sold[/TD]
[TD]Amount.[/TD]
[/TR]
[TR]
[TD]Assistive Furniture[/TD]
[TD]2167[/TD]
[TD]342043.83[/TD]
[/TR]
</tbody>[/TABLE]
&
for Sub-Category
[TABLE="width: 500"]
<tbody>[TR]
[TD]Catergory[/TD]
[TD]Sub-Category[/TD]
[TD]Qty Sold[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]Assistive Furniture[/TD]
[TD]Bed & Accessories[/TD]
[TD]400[/TD]
[TD]61618.07[/TD]
[/TR]
</tbody>[/TABLE]
Is there a way to do quickly or automatically? It would take me several hours to do this especially with 166 Sub-Categories.
Thank
Last edited: