Pivot table data into excel sheet dynamically

[subrahmanyam85]

Hi,

I have a pivot table like below.

Year	Ryear	Version	Category	Product	Value
2011	2011	GL	Cat A	P1	205
2011	2013	K	Cat B	P2	202.3
2008	2013	T	Cat B	P3	110.5
2004	2011	GL	Cat A	P4	45
2008	2011	K	Cat C	P5	89

<tbody>
</tbody>

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)

Year	Ryear	Version	Category	P1	P2	P3	P4	P5
2004	2011	GL	Cat A				45
2008	2011	K	Cat B					89
2008	2013	T	Cat C			110.5
2011	2011	GL	Cat A	205
2011	2013	K	Cat B		202.3

<tbody>
</tbody>

Can you please let me know how to achieve this?

I am hitting my head against my monitor...

 

[cyrilbrd]

Hi,
how are P1 to P5 fields arranged in your raw data?
what do you mean by dynamically? do you want the pivot to refresh without having to call refresh? or do you want the range to consider new rows? thanks to clarify.