Evening OcUK!
Right, not quite sure how to do this one.
I've got a PT set up just how I want it in terms of layout, but I need a bit of automation.
In row labels, I have Sigma values and a Category, such that I get a layout like
Category1
etc etc
What I want to be able to do though, is what is selected for the second Dataset (i.e. Dataset2 in this example), is for every single column in the PT, show it as a Difference From relative to Dataset1.
This is easy to accomplish by right click the relevant column, changed Show Values As to Difference From, and hey presto. Unfortunately, with the number of Categories I've got, and the number of columns, it will be hours and hours work just to set this up.
So, is there any clever way of automating this, either through PT settings, or a Macro?
Thanks in advance for any and all help!!
Right, not quite sure how to do this one.
I've got a PT set up just how I want it in terms of layout, but I need a bit of automation.
In row labels, I have Sigma values and a Category, such that I get a layout like
Category1
Dataset1
Dataset2
Category2Dataset2
Dataset1
Dataset2
Dataset2
etc etc
What I want to be able to do though, is what is selected for the second Dataset (i.e. Dataset2 in this example), is for every single column in the PT, show it as a Difference From relative to Dataset1.
This is easy to accomplish by right click the relevant column, changed Show Values As to Difference From, and hey presto. Unfortunately, with the number of Categories I've got, and the number of columns, it will be hours and hours work just to set this up.
So, is there any clever way of automating this, either through PT settings, or a Macro?
Thanks in advance for any and all help!!