Last answered:

05 Mar 2023

Posted on:

13 Nov 2022

0

what about this error when making pivot table

image.png

1 answers ( 0 marked as helpful)
Posted on:

05 Mar 2023

0

U should have calculated the (SUM) of values (Volumes , Gross Sales , Net Sales , etc) , but in ur Pivot table the (COUNT) of these values are showen . U should click on the (Values) Field at the right side of the sheet , then select the last option (Values Field Settings) , then click the (SUM) not (COUNT) . Good Luck !

Submit an answer