Manipulation of script fields

[ranibosch]

hic‌

Good day,

My data pulls as follows with my current script:

Would it be possible to amend to look like the bottom table?

[sunny_talwar]

How did you choose MFGTYPE out of the three among Trending Code? Also, is this something you need from script?

[ranibosch]

Hi,

Basically I'm busy with sales trending.

The 3 lines populated for the same document is my 3 trending codes.

I used my packsize trending code to calculate the invoiced units field.

But ultimately I want the units sold result next to each trending code (MFGTYPE and SERVICE)

Currently what I want to achieve in my object is to sum the invoiced units, if MFGTYPE is equal to MP, HP or SHP.

This will then compare the units sold of machine packed, hand packed and semi-hand packed.

[Anonymous]

Maybe?

=if([Trending Code]='MFGTYPE',sum(aggr(sum([Invoiced Units]),[Item No])))