Dynamic columns in table.

[Anonymous]

Hello,

Let's say we have following input set:

A   2000   1

B   2000   2

A   2001   5

B   2001   4

A   2002   2

B   2002   8

I need someting similar to Time Chart Wizard which will generate report:

     2000   2001  2002

A        1        5        2

B        2        4        8

but the key thing is that with wizard I'm forced to add all columns ( 2000, 2001, 2002 )  manually.

Is there any better way to do that and automate that process to avoid "clicking". If we have 3 columns

it makes no difference, but when we are close to 50 it's getting painful ?

[Anonymous · Accepted solution]

Found it "Always fully expanded"  in presentation tab.

[MayilVahanan]

Hi

Name2 : A, Name3:C has value2 for year 2000 only. so for remaining its display null value.Same way for remaining case.

So in this case, you can use ordinary straight or pivot table..

PFA