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
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
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.
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
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?!
Hi,
I don't think this is possible in web reporting.
Thanks,
Raju