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!
you can try this:
Load"Date",Mark,Part_No,ValueFROM [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'