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 -
<tbody>
</tbody>
&
for Sub-Category
<tbody>
</tbody>
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 -
Category | Qty Sold | Amount. |
Assistive Furniture | 2167 | 342043.83 |
<tbody>
</tbody>
&
for Sub-Category
Catergory | Sub-Category | Qty Sold | Amount |
Assistive Furniture | Bed & Accessories | 400 | 61618.07 |
<tbody>
</tbody>
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: