showing in Pivat chart the grandtotals from a subtotals colum

[JACKNIEKERK]

having order grid with sub totals in kilo, pices, euro,  grid is sorted by  orders,customer ,

need at the right side of chart colum showing per customer his total order value

please see screenprint for sample , thanks

[JACKNIEKERK · Accepted solution]

was sofar only solvable by adding a extra chart ,see screenshot and expression