Mapping with custom rules

Mon, 20 Apr 2015 15:36:31 GMT

Hi to everyone,

kindly ask for help!

I have a pivot table like this (example):

My goal is to have something like this:

So, when, in a Site I have:

CODE NEW CODE

only A (or only B or only C) -> A

A+B -> AB

A+other -> A

I think it's a kind of mapping, and I want to do it in presentation, but I don't know how I can aggr by Site (something with concat function?) .

Maybe the worst is remove , ad example in Site 001, rows with only A (or only B, or C).

Sorry if this is not clear, I don't know how make it easier

topic Mapping with custom rules in QlikView