Any way to do per task item charts? See pie chart of Value, Discounts, Totals, all within a deal chart?

I’m looking for a way where I can see in a visualization of the item’s data how much of the was deducted like a pie chart or stacked chart that has the total amount, say $1000, and then 30% went to customer discounts, and 10% went to reseller.

I tried the chart view but I can’t seem to get it to focus on the deal itself specifically and keeps wanting to use connection board reference instead. I tried the product, thinking that would help, but doesn’t seem to give me really any options.

Here are the columns and the type
unit price - (mirrored)
quantity - (number)
deal value - (automatic)
volume discount - (dropdown column)
After Volume Discount - (formula)
Rate - (formula)
Total Customer Discount Amount (formula)
Subtotal (formula)
Authorized Reseller Discount - (mirrored)
Reseller Discount Amount ($) - (formula)
Total Discounts Amount - (formula)
Total ($) - (formula)

Is it that I’m doing something wrong, or that it’s not possible with these charts or that formula and mirror columns don’t work?

Here are some screenshots to help with the visuals