> For the complete documentation index, see [llms.txt](https://docs.coffbox.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coffbox.com/usage-examples/monthly-sales-breakdown.md).

# Monthly Sales Breakdown

Analyze monthly sales by product category

## Sample Data

![](/files/MQGxLKkbQIEcYwTd4Nal)

## Prompt

> Calculate the sales volume of each Sub-Category for each month in 2016, with one row for each Category data, showing the months in columns, and the first two columns being Category and Sub-Category.

## Excel Cursor Response

![](/files/dgADYfjYcCro6gpFQZyl)

## Result

![](/files/r5ihhrbmzutq9l4EIgwv)