calculate by partly filtered value

[BlazkoG]

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!

[Ksrinivasan]

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