sub-sub totals in chart

[JACKNIEKERK]

have a pivot chart with option for always fully expanded on, 1 expression for rows:

sum(Pick(match(FakUnitType,'K','S'), FakKilos * FakPrijs, FakStuks * FakPrijs))  in most right colum  Sales €

needed  a subtot off ALL sales on top line

AND a sub total between  every custoNr per customer ?

see attached screen please, thanks

[MayilVahanan · Accepted solution]

Hi @JACKNIEKERK 

You can create the sub total based on below option in pivot table

[JACKNIEKERK]

that clik works to show subtotals
then i have  still one support help question,  please look at screen sample2 first that would be the most
nice way to show, or as other option sample1
thanks