Not sure if I was descriptive enough regarding my problem but has anyone encounter this problem where you drag one of the fields and put into the Values, it always return as "Count of", instead of "Sum of"
How can we change it to "Sum of" by default everytime we drag a data fields into Values Field List?
I got 20-30 months of data need to plot into that field list, but have to manually change to "Sum of"..... that's pretty much manual
I'm using excel 2010, the old version do not have such problem (although once a while it appears the same...)
I've attached the snapshot for clearer view