> 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

![](https://546336154-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvWR9jmxX1LV6WplIPRhL%2Fuploads%2Fgit-blob-5681487c0ccc281af938828408ceaae564cdfaff%2Fcase01_01.png?alt=media)

## 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

![](https://546336154-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvWR9jmxX1LV6WplIPRhL%2Fuploads%2Fgit-blob-fa7f1adcc170d60534a4e64d22a34b17b8f9603d%2Fcase02_01.png?alt=media)

## Result

![](https://546336154-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvWR9jmxX1LV6WplIPRhL%2Fuploads%2Fgit-blob-d4428b0876156748c21cc878bcf6e06d4476048a%2Fcase02_02.png?alt=media)