How to pivot vertical table data to Cross table in webi

building reports webintelligence
1

Hi Folks,

I was trying to create pivot table based on the Vertical table in SAP BO 4.2 SP3 webi. I having trouble to align the data in single column view, for more info please check in the attached screenshot …

image
image1427×592 34.9 KB

2

that’s no content to be displayed as a pivot table.
in pivot you have attributes as row+columns and values as measure.
there is nothing to be count/sum/max/min and “Party Line 1” is different in EVERY row so it can’t be used as column.

you can create an additional variable that contains all your column-logic and the output can be something like “Column1”, “Column2”, etc., this variable then can be used as the column in a pivot-table,
and the measure has to be e.g. max([Party Line 1])

or you can add all PartyLine-values into one single field with a formula like this:
http://www.djames.net/BIBlog_Entries/How-to-get-multiple-values-into-one-cell