topic sub-sub totals in chart in QlikView

sub-sub totals in chart

JACKNIEKERK — Fri, 15 Nov 2024 23:21:07 GMT

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

Re: sub-sub totals in chart

MayilVahanan — Sun, 10 Jan 2021 01:40:16 GMT

Hi @JACKNIEKERK

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

Re: sub-sub totals in chart

JACKNIEKERK — Sun, 10 Jan 2021 11:30:38 GMT

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