sum each row for all items by type

[JACKNIEKERK]

in graphic I have now Expression:
sum(Pick(match(FakUnitType,'K','S'), FakKilos * FakPrijs, FakStuks * FakPrijs))

is total off all rows, thats ok, but need per row subtotals based PLU field (Price Lookup Unit) = itemnuber)

This total sum on line Orange Jus etc.

wich script /epression i need for that, please see sample screenshot

would like too see 1 line Orange jus , total  54.45 

[Anil_Babu_Samineni · Accepted solution]

You can change that object to pivot table and enable partial sum for PLU?

[QFabian]

Hi @JACKNIEKERK , try adding some code to your expression :

sum ( <TOTAL TotallizerField >   rest of your expression)

[JACKNIEKERK]

hello,  can't get it right in syntax, will see suggestions,(see screenshot)  please advise with sample

wat syntax should be,  thanks 

[JACKNIEKERK]

i recreated as pivot table as advised , now  ok, thanks