Forum Discussion
pmr2000
7 years agoFrequent Visitor
Cannot change from count to a sum
I have a line and stacked column chart. The stacked column values appear fine, when I add a field to the line values I can only get "count" - no option to change to "sum". The pulldown does not...
pmr2000
7 years agoFrequent Visitor
If I try the line value in another using YTD Target I get sum - however it is adding the entire row of months together and giving me flat line of January to December as the sum of the column, not individual values for each month?
pmr2000
7 years agoFrequent Visitor
I don't see the delta summation symbol next to the column I want as line graph - how can I change that?
- parry2k7 years agoSuper User
pmr2000 that tells me that it is not a number field, can you share the screen shot with selected field and data type of the field.
- pmr20007 years agoFrequent Visitor
I was able to create a new table in excel, refresh, seems to work now.
Can't see any issue with the old data not being formatted correctly but like you said the summation delta symbol indicates an issue.
Thanks so much!