Group By Results in a Table

[Anonymous]

Hi All,

i would like to group by results in a chart, based on a logic,

Let's look at this example:

in any case an ID has a product type like premium or plus, show it

in case an ID has only basic product type, show the basic

*show only 1 row per ID

how can i do this in a straight table/ pivot table?

[alexandros17]

Why premium is the value associated? must It Always be premium? what if Premium do not exists among record to be grouped?

[maxgro]

maybe this expression

subfield(concat(Type, '@'), '@', -1)

[Anonymous]

it doesn't have to be premium,

in case there is base - then base,

in case there is premium/Plus - then premium/plus