Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can change that object to pivot table and enable partial sum for PLU?
You can change that object to pivot table and enable partial sum for PLU?
Hi @JACKNIEKERK , try adding some code to your expression :
sum ( <TOTAL TotallizerField > rest of your expression)
hello, can't get it right in syntax, will see suggestions,(see screenshot) please advise with sample
wat syntax should be, thanks
i recreated as pivot table as advised , now ok, thanks