Skip to Content

SAP Business Objects Webi Cross Tab report

Dec 13, 2016 at 07:41 AM


avatar image
Former Member


I am facing an issue to get the column to the cross tab report, then the column is empty.

i have created an variable with if condition and pulled the same in the report .


= If [Difference] < 1 Then "A" Else If ([Difference] >= 1 And [Difference] <= 3) Then "B" Else If ([Difference] >= 4 And [Difference] <= 6) Then "C" Else "D"

Now while using this condition . i am getting only two columns in the report A&B , since there is data only for A& B . But i want columns C and D in the reports and its value as 0.

Please tell me how can i get the columns when there is no data .


Arun K

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Dec 13, 2016 at 09:54 AM

Hello Arun,

In this case you can create 4 static columns named A,B,C, D and then for each column you can write condition.

There will be 4 Condition for 1 for each column with Else part as "0"


Sushil Padhye

10 |10000 characters needed characters left characters exceeded