Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all! Please help to construct a straight table with dimensions of supplier and service and expression of sum of purchases for those suppliers who provided service only once. The table has been attached.
May be this:
SCRIPT:
SupplierService:
LOAD Supplier,
Service,
[sum(Сумма)]
FROM
[C:\Users\u953550\Downloads\Supplier Service.xlsx]
(ooxml, embedded labels, table is Sheet1);
SupplierServicedOnce:
LOAD *
WHERE Flag = 1;
LOAD Supplier,
COUNT(Service) AS Flag
Resident SupplierService
Group By Supplier;
CHART:
//Dimension
Supplier
//Expression
Count({<Flag={1}>}Service)