Crosstab Webi report

[Former Member]

Hello,

I need  to create some dummy columns at the end of the cross tab, any ideas

The cross tab may look some thing like

     A     B   C  D  E       

1

2

3

where the 1,2,3 are rows and A,B,C D and E are columns, both are data objects. Hence the cross tab can expand,

In my case the crosstab can increase / decrease the number of columns represented by the object (Column headers).

Is there an example, where i can add some blank columns at the end of the cross tab.

I need this functionality such that it can be consumed by live office connection in Dashboards

Sanjay

[Former Member · Accepted solution]

Hi Sanjay,

If I am not wrong, you cannot add columns; however, you can add footers to the crosstab which will actually look like columns.

Then you can try to insert the block into Dashboard using LiveOffice.

Give it a try.

Regards,

Yuvraj

[Former Member · Accepted solution]

Thanks Yuvraj,

So simple - I added total (Sums) which added a column that sums up the rows. The when you highlight the sum column webi does allow to add additional columns, which act as dummy columns. I have tested this via Dashboard and LO connection and seems to work.

Thanks again

Sanjay