Product wise Total

[#1]

Dear All

I need help on below Requirement:

Any help would be appreciated.

Regards

ERic

[PrashantSangle]

Hi,

In script You need to use simple sum() with group by product.

Regards,

[susovan]

Thank you sir for your valuable suggestion ,

[#4]

Hi Eric,

Try this in script..

testtttt:

LOAD Proposal,

     Value,

     Product

FROM

Sample_Test.xlsx

(ooxml, embedded labels, table is Sheet1);

Left Join(testtttt)

LOAD Product,sum(Value) as total Resident testtttt group by Product;

final:

LOAD *,Value/total as [Desired Result] Resident testtttt;

drop table testtttt;

Thanks,

[sunny_talwar]

For backend you can try this:

Table:

LOAD * INLINE [

    Proposal, Value, Product

    1111, 1000, CAR

    1112, 2000, CAR

    1113, 3000, TRUCK

    1114, 4000, TRUCK

    1115, 5000, TRUCK

    1116, 6000, TEMPO

    1117, 7000, TEMPO

    1118, 8000, BIKE

];

MappingTable:

Mapping

LOAD Product,

  Sum(Value)

Resident Table

Group By Product;

FinalTable:

LOAD *,

  Value/ApplyMap('MappingTable', Product) as [Desired Result]

Resident Table;

DROP Table Table;