Excel Pivot Table In Webi

building reports webintelligence
1

Is it possible to emulate Excel’s pivot table in Webi?

Something that looks like this format:

938×389

I tried using Crosstab but doesn’t work and it looks ugly… It doesn’t allow the nesting and grouping feature that excel has…

outatime (BOB member since 2007-11-20)

2

I believe you can only achieve this with a BW data source.

http://businessobjectsbi4.blogspot.co.uk/2013_04_01_archive.html

Otherwise you will have to leave on display and format as best you can.

Mak 1 :uk: (BOB member since 2005-01-06)

3

Hi,

If you are talking about the look of the first column in your pivot table, then have a look at this blog post of mine where I described how to achieve something similar in a WebI report using breaks and a bit of formatting:
http://www.perpendulum.com/2011/12/hierarchy-in-one-column/

Marek Chladny :slovakia: (BOB member since 2003-11-27)

4

i don’t see why you wouldn’t be able to achieve that look using crosstab and breaks

erik.stenson :us: (BOB member since 2012-07-30)

5

thank you! this is good stuff!

outatime (BOB member since 2007-11-20)