Excel Report - Excel Pivot Table is Datasource

[subrahmanyam85]

I have to create a report in excel.I have to use a pivot table as datasource.

For example my pivot table is like below.

Year column is dynamic(count may decrease or increase)
Year Category Value
-----------------------------
2009 A 58
2012 A 10
2014 B 9
2013 c 7
2014 C 12
2012 c 54
2013 B 8

In my excel report I have to show like below.

Year A B C
--------------------------------------
2009 58 0
2012 10 0 54
2013 0 8 7
2014 0 9 12
--------------------------------------
Total 68 17 73

Please give me a solution for this.

Thanks
Subbu

 

[par60056]

Welcome to the forum.

The best way to start learning to work with pivot tables (and many other parts of Excel) is to use the macro recorder and record doing it by hand then look at the code. The code generated by the macro recorder will have lots of extra stuff in it that can be trimmed out. It will also be fixed based on what you did by hand and you will need to modify it to handle dynamic amounts of data.

Once you have taken a shot at it, you can post your code with questions and people will be glad to help you.

Make use of the CODE /CODE tags around your code. Put the tags in square brackets at the beginning and end.

 

[ParamRay]

.
.

This looks like a straightforward Insert --> PivotTable --> PivotTable solution.

"Year" should be a Row Field
"Category" should be a Column Field
"Value" should be a Data Field