cancel
Showing results for 
Search instead for 
Did you mean: 

How do I get columns with no Data to show up in a crosstab

Former Member

I have tried to check and uncheck the Null Values field in Report Options. In Cross-Tab expert, I do not have Suppress empty columns (nor rows) checked. I have also tried the below formula:

if CurrentFieldValue = " " then "0" else ToText(CurrentFieldValue)

.

Nothing is working. I still don't see my columns unless there is data.

Please help

Accepted Solutions (0)

Answers (1)

Answers (1)

RoS_Data
Discoverer
0 Kudos

I can't believe nobody answered this question at the time. I was looking for just this: "How do I get columns with no data to show up in a crosstab". This must be an issue which lots of people have come across, surely. For example, you might want to show all the products you sell to show in a crosstab, regardless of whether you sold any during the week for which you ran your report. Webi normally doesn't work like this, and it only shows fields with data.

For me being able to do this was particularly important because the data is feeding into a bigger report in Excel, and missing columns cause annoying problems. I found a suggestion elsewhere in the SAP community, but I can't find it again now. I couldn't believe I'd not thought about this, but all it needed was a list of all columns (e.g. a list of all products you sell) in an Excel workbook, and using this as an additional data source. I then merged the dimensions and this solved the issue. 

Just adding this now in case it's of use for anyone else looking for a solution.