Forum Discussion
Wrong Aggregated values in Clustered Column Chart
I have created a simple column chart showing the week on week sales but the aggregation is wrong using Sum and chart shows wrong values. I have a following data (sample): Employee Week Sales...
I am having this same problem. I have two columns of data, both of which are formatted as whole numbers and contain either the value 1 or null. One column it sums correctly (a total of 29), the other column it does not (returns the same, lesser value of 29 instead of the 40 that you can visually see in the table). Any thoughts?