> ## Documentation Index
> Fetch the complete documentation index at: https://parabola.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# Transforming data
In this lesson, you'll learn the three broad categories of data transformations — calculations, business logic, and formatting — and see how to apply them in your flow.
***
With your data combined, calculate revenue per line item and roll it up by category to produce the final Sales by Category summary. Copy and paste this prompt into Parabola:
```text wrap theme={null}
Calculate a new column called "Total Sales" by multiplying "Line Item Price" by "Units". Then sum "Total Sales" grouped by "Category Name". Format "Total Sales" as currency with two decimal places — for example, $10,000.00.
```
The steps added to your canvas and their exact documentation may differ from what you see below — every AI response is unique. The important thing is that your resulting data set matches what you see here.
