Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want tu sum 'value' field as below. Filter by 'mark' field., and I want to do this in set analysis.
So i Want to sum by 'part_no', for every part_no that has occurence of filtered 'mark' field.
I could do this in script editor, but there are tens of distinct 'mark' values, and I want to calculate this in dynamic way.
I might filter more than one value.
Thx in advance for help!
hi,
you can try this:
XXXX:
Mapping
Load
Part_No,
Mark;
Load
"Date",
Mark,
Part_No,
Value
FROM [lib://REPORT EXTRACTION /TEST/SSSS1.xlsx]
(ooxml, embedded labels, table is Sheet25)
Where not Mark='-';
DDDD:
LOAD
"Date",
Mark,
Part_No,
ApplyMap('XXXX',Part_No,'') as dede,
Value
your expected Result:
if you select 'X' here that DIM field name is dede:
if you select 'Y'
ksrini