Hi
When I apply break in WEBI the table brekas vertically by giving the information one below the other. For example I have 3 fields like Country, Order ID, no. activity instances
when I apply break on country it shows the data like this
country 1: order id instances 1 23 2 43 3 45 country 2: order id instances 4 56 5 76 6 12
But since I have only two columns I dodn't want to waste the remaninng space in my report and i want the output like this
country 1: country 2: order id instances order id instances 1 23 4 56 2 43 5 76 3 45 6 12
I tried using crosstab but since the orderids are not same for both the countries i'm getting blanks for the other countries and the output is like this
country 1: country 2:
order id instances order id instances
1 23
2 43
3 45
4 56
5 76
6 12
The only way what I found was to place multiple blocks side by side and apply filter on each block. But by doing this the report needs manual work for every new country as the data is dynamic and the number of countris varies based on filter condition.
I want this format dynamically. Is there any option available for breaks to show the data side by side?
I appreciate your help!!!!!
Thanks
Raghavendra.G