Could you please help me with this on both calculated dimension and on script level.
Cumulation could be done on "ReceivedQty"
Script:
LOAD if(isnull(UPPER(po_version)),'-',UPPER(po_version)) as "Base", po_version as "Target", UPPER(ems) as "EMS*", UPPER(mpn) as "MPN*", UPPER(maker) as "MAKER*", UPPER(supplier) as "SUPPLIER*", po_version&supplier as test, upper(NPI_flag) as "NPI Flag_V", months as "MONTH*", year as "YEAR*", if( months&'-'&year >0,months&'-'&year) as MonthYear, if(Ceil(Month(Date#(months&year, 'MMMYYYY'))/3)&'-'&year>0, year&'-'&'Q'&Ceil(Month(Date#(months&year, 'MMMYYYY'))/3)) as "Quarter*", ReceivedQty as "Delivered Quantity", BalanceQty as "Balance Quantity", Total_RequestedQty , text("commodity_type") as "Commodity Type",
processed_at Where Left(ems, 3) <> 'PNE'and months <> 'None';
