subrahmanyam85
New Member
- Joined
- Aug 26, 2014
- Messages
- 20
Hi,
I have a pivot table like below.
[TABLE="width: 411"]
<tbody>[TR]
[TD]Year
[/TD]
[TD]Ryear
[/TD]
[TD]Version
[/TD]
[TD]Category
[/TD]
[TD]Product
[/TD]
[TD]Value
[/TD]
[/TR]
[TR]
[TD="align: right"]2011
[/TD]
[TD="align: right"]2011
[/TD]
[TD]GL
[/TD]
[TD]Cat A
[/TD]
[TD]P1
[/TD]
[TD="align: right"]205
[/TD]
[/TR]
[TR]
[TD="align: right"]2011
[/TD]
[TD="align: right"]2013
[/TD]
[TD]K
[/TD]
[TD]Cat B
[/TD]
[TD]P2
[/TD]
[TD="align: right"]202.3
[/TD]
[/TR]
[TR]
[TD="align: right"]2008
[/TD]
[TD="align: right"]2013
[/TD]
[TD]T
[/TD]
[TD]Cat B
[/TD]
[TD]P3
[/TD]
[TD="align: right"]110.5
[/TD]
[/TR]
[TR]
[TD="align: right"]2004
[/TD]
[TD="align: right"]2011
[/TD]
[TD]GL
[/TD]
[TD]Cat A
[/TD]
[TD]P4
[/TD]
[TD="align: right"]45
[/TD]
[/TR]
[TR]
[TD="align: right"]2008
[/TD]
[TD="align: right"]2011
[/TD]
[TD]K
[/TD]
[TD]Cat C
[/TD]
[TD]P5
[/TD]
[TD="align: right"]89
[/TD]
[/TR]
</tbody>[/TABLE]
Here products are fixed P1 to P5 remaining all column values are not fixed.
Year starts minimum 1993 and Max year is current year.
I have to show the data like below.(Pivot table increasing dynamically)
[TABLE="width: 603"]
<tbody>[TR]
[TD]Year
[/TD]
[TD]Ryear
[/TD]
[TD]Version
[/TD]
[TD]Category
[/TD]
[TD]P1
[/TD]
[TD]P2
[/TD]
[TD]P3
[/TD]
[TD]P4
[/TD]
[TD]P5
[/TD]
[/TR]
[TR]
[TD="align: right"]2004
[/TD]
[TD="align: right"]2011
[/TD]
[TD]GL
[/TD]
[TD]Cat A
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]45
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2008
[/TD]
[TD="align: right"]2011
[/TD]
[TD]K
[/TD]
[TD]Cat B
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]89
[/TD]
[/TR]
[TR]
[TD="align: right"]2008
[/TD]
[TD="align: right"]2013
[/TD]
[TD]T
[/TD]
[TD]Cat C
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]110.5
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]2011
[/TD]
[TD="align: right"]2011
[/TD]
[TD]GL
[/TD]
[TD]Cat A
[/TD]
[TD="align: right"]205
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]2011
[/TD]
[TD="align: right"]2013
[/TD]
[TD]K
[/TD]
[TD]Cat B
[/TD]
[TD][/TD]
[TD="align: right"]202.3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Can you please let me know how to achieve this?
I am hitting my head against my monitor...
I have a pivot table like below.
[TABLE="width: 411"]
<tbody>[TR]
[TD]Year
[/TD]
[TD]Ryear
[/TD]
[TD]Version
[/TD]
[TD]Category
[/TD]
[TD]Product
[/TD]
[TD]Value
[/TD]
[/TR]
[TR]
[TD="align: right"]2011
[/TD]
[TD="align: right"]2011
[/TD]
[TD]GL
[/TD]
[TD]Cat A
[/TD]
[TD]P1
[/TD]
[TD="align: right"]205
[/TD]
[/TR]
[TR]
[TD="align: right"]2011
[/TD]
[TD="align: right"]2013
[/TD]
[TD]K
[/TD]
[TD]Cat B
[/TD]
[TD]P2
[/TD]
[TD="align: right"]202.3
[/TD]
[/TR]
[TR]
[TD="align: right"]2008
[/TD]
[TD="align: right"]2013
[/TD]
[TD]T
[/TD]
[TD]Cat B
[/TD]
[TD]P3
[/TD]
[TD="align: right"]110.5
[/TD]
[/TR]
[TR]
[TD="align: right"]2004
[/TD]
[TD="align: right"]2011
[/TD]
[TD]GL
[/TD]
[TD]Cat A
[/TD]
[TD]P4
[/TD]
[TD="align: right"]45
[/TD]
[/TR]
[TR]
[TD="align: right"]2008
[/TD]
[TD="align: right"]2011
[/TD]
[TD]K
[/TD]
[TD]Cat C
[/TD]
[TD]P5
[/TD]
[TD="align: right"]89
[/TD]
[/TR]
</tbody>[/TABLE]
Here products are fixed P1 to P5 remaining all column values are not fixed.
Year starts minimum 1993 and Max year is current year.
I have to show the data like below.(Pivot table increasing dynamically)
[TABLE="width: 603"]
<tbody>[TR]
[TD]Year
[/TD]
[TD]Ryear
[/TD]
[TD]Version
[/TD]
[TD]Category
[/TD]
[TD]P1
[/TD]
[TD]P2
[/TD]
[TD]P3
[/TD]
[TD]P4
[/TD]
[TD]P5
[/TD]
[/TR]
[TR]
[TD="align: right"]2004
[/TD]
[TD="align: right"]2011
[/TD]
[TD]GL
[/TD]
[TD]Cat A
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]45
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2008
[/TD]
[TD="align: right"]2011
[/TD]
[TD]K
[/TD]
[TD]Cat B
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]89
[/TD]
[/TR]
[TR]
[TD="align: right"]2008
[/TD]
[TD="align: right"]2013
[/TD]
[TD]T
[/TD]
[TD]Cat C
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]110.5
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]2011
[/TD]
[TD="align: right"]2011
[/TD]
[TD]GL
[/TD]
[TD]Cat A
[/TD]
[TD="align: right"]205
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]2011
[/TD]
[TD="align: right"]2013
[/TD]
[TD]K
[/TD]
[TD]Cat B
[/TD]
[TD][/TD]
[TD="align: right"]202.3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Can you please let me know how to achieve this?
I am hitting my head against my monitor...