C4C reporting exchange / map values (avoid # / hashtag)

[nik_bach1]

Hello experts,

I've got the # ( hashtag-sign) in my report and view other values, which I want to "exchange" or "map".

This is the original data.

now let's say. I want to exchange the value for column Gender like this:

1 = m

0 = <empty> (No # hashtag-sign)

2 = f

it should look like this afterwards

Does anyone know what is the best way to perform it?!

Thanks

Nik

[former_member269156]

Hi,

You can try as follows :

Convert Grid Display to Excel Table Display

Just key in Excel formula in last column of the report result as

=IF(F3="1","M",IF(F3="2","F"," " )) *assumption F3 is Gender column

This formula will be auto adjusted to all rows.

Thanks,

Raju

[nik_bach1]

Hi Raju,

just to make sure I understand you correctly.

You suggest to do it in Microsoft Excel, after "saving the report as file"?

If so, well that's exactly what we want to avoid.

[former_member190501]

Hi,

Convert Grid Display to Excel Table Display - this is not saving the report as file.

Once you convert to Excel Table Display your excel formula automatically recognized based on query result.

Thanks,

Raju

[nik_bach1]

Hi Raju, thx for your answer.

The issue is still, that the customer wants to see "M"-value or "F"-value in SAP C4C, not in excel.

So let's say, we are not allowed even to think about using Excel, when looking for a solution of my question :=)

Is it possible to do it somehow with key figures?!

[former_member269156]

Hi,

I don't think this is possible in web reporting.

Thanks,

Raju