Forum

Notifications
Clear all

Pivot Table Help

4 Posts
3 Users
0 Reactions
131 Views
(@icdeadppl)
Posts: 2
New Member
Topic starter
 

 Hi

 

I'm trying to use a pivot table to extract data and graph Baseline vs Current in a stacked Column Graph but having all sorts of trouble with the multiple date columns, any assistance would be appreciated.

 
Posted : 17/09/2017 12:05 am
Anders Sehlstedt
(@sehlsan)
Posts: 974
Prominent Member
 

Hello Gordon,

As I see it, if you want to use the current layout of your data table/range then you need to create a "helper table/range" where you use functions to sum the Baseline and Current columns per year and month and then create a chart.

As you can see I have created two new sheets in your document, where I have restructured the data in your range.

This will give you what you look for (as I have understood your issue) when using Pivot Table and Pivot Chart.

Br,
Anders

 
Posted : 18/09/2017 8:37 am
(@icdeadppl)
Posts: 2
New Member
Topic starter
 

Thanks Anders

 

I appreciate the efforts, this sort of manipulation is what I was trying to avoid.

 

Regs

 

G

 
Posted : 18/09/2017 6:03 pm
(@david_ng)
Posts: 310
Reputable Member
 

I think no choice we have to tidy up our data before generate any sensible report.

 
Posted : 19/09/2017 2:24 am
Share: