Skip to Content
0
Former Member
Mar 31, 2011 at 06:41 PM

Hide and Expand in Web Intelligence

262 Views

Hello:

I am very new to the tools, so please let me know what I am thinking is even possible.

We are thinking about making a report that allow User to hid and Expend almost like what they do in Excel. For example Report initially shows in Column by year, so 2008, 2009, 2010, 2011. Then if you click on 2010 or maybe a plus sign on 2010 (making up stuff here), then it will should 2010 also in quarters.

So format like this

  1. 2008 | 2009 | 2010 | 2011

1

2

3

4

becomes

  1. 2008 | 2009 | 2010 | 2010Q1 | 2010Q2 | 2010Q3 | 2010Q4 | 2010

1

2

3

4

And user can then decide to expend something else or contract the existing expansion?

Is it also possible on the row level. So like think

  1. 2008 | 2009 | 2010 | 2011

1

2

3

4

Becomes

  1. 2008 | 2009 | 2010 | 2011

1

2

2a

2b

2c

2d

3

4