Hi there,
For any of you excel bods out there im needing some help with some pivots tables that im trying to create in Excel.
Basically I am basing the pivot tables around some data from one of my sheets. This can be seen here -
Im wanting to use the 'Product Number' and the 'End' values so that they show side by side in the pivot tables. e.g. - M04 - 4,588.
When I get to the pivot table I drag the 'Product Number' into the 'Row' array and then I try to drag the 'End' section into the middle 'Data' array.
However when I do this it sets all the numbers in the 'End' section to 1.
Like this;
It seems to be doing a sum of the field and not actually just displaying the number. I can get it to work so that I have both of them in the 'Row' section of the pivot table but when I go to do a graph it just looks silly.
Like this;
I would settle with leaving it like this if I could get rid of the "drop data and column" messages.
Anyone help
For any of you excel bods out there im needing some help with some pivots tables that im trying to create in Excel.
Basically I am basing the pivot tables around some data from one of my sheets. This can be seen here -
Im wanting to use the 'Product Number' and the 'End' values so that they show side by side in the pivot tables. e.g. - M04 - 4,588.
When I get to the pivot table I drag the 'Product Number' into the 'Row' array and then I try to drag the 'End' section into the middle 'Data' array.
However when I do this it sets all the numbers in the 'End' section to 1.
Like this;
It seems to be doing a sum of the field and not actually just displaying the number. I can get it to work so that I have both of them in the 'Row' section of the pivot table but when I go to do a graph it just looks silly.
Like this;
I would settle with leaving it like this if I could get rid of the "drop data and column" messages.
Anyone help
Last edited: