How to merge two values of one dimension via chart function

[ingo_lsg]

Hi experts,

I have one dimension with e.g three values

A,

B,

C,

Now I want to merge A and B in the chart (not via applymap in the script) to aggregrate their KPI value. I have to create a calculated dimension for this, right?. But my attempts all failed.

Any suggestions?

BR Ingo

[NitinK7]

Hi,

Not understood your question

can you explain using some examples

[ingo_lsg]

Hi,

my data looks like this:

Dim, Value

A, 10

B, 20

C, 30

Now it should look like:

Dim, Value

A (represents A and B), 30 (A+B)

C, 30

Does this help?

BR

Ingo

[ingo_lsg]

Hi guys,

come on!

Nobody could help?

BR

Ingo

[Kushal_Chawda · Accepted solution]

Option 1 : Recommended

Dim:
Load * Inline [
List
1
2 ];

Data:
Load * Inline [
Dim, Value
A, 10
B, 15
C, 30];

Dimension:
=pick(List,'A-B',Dim)

Expression:
=pick(List,sum({<Dim={'A','B'}>}Value),sum({<Dim-={'A','B'}>}Value))

Option 2: Without script

Data:
Load * Inline [
Dim, Value
A, 10
B, 15
C, 30];

Dimension:
=aggr(if(match(Dim,'A','B'),'A-B',only({<Dim-={'A','B'}>}Dim)),Dim)

Expression:
=if(not match(Dim,'A','B'),sum({<Dim-={'A','B'}>}Value),sum({<Dim={'A','B'}>}Value))

[ingo_lsg]

Many thanks!