My question is about merging values for both the title field (= the company name) and various fields. I'm currently using the Charts module.
In the picture below, it shows a column chart that displays a content type with a field of title, integer field (labeled 2017), and another integer field (labeled 2018). In this view, I have a chart (showing title and 2017) and a chart add-on (title and 2018).
Here is how the table about these data looks like:
Company ! 2017 ! 2018 ----------+------+----- Company A ! 5 ! 6 Company B ! 2 ! 3
What I want to do is SUM all the values of the 2017 field into one column and values of 2018 into one column.
I tried using the Views Merge Rows module and configured the option to SUM all the values of 2017 and 2018 into one column, but it's not working for me. The chart (showing title and 2017) works since it combines all values, but the chart add-on splits apart and I don't know why.
This is what I get:
Is there a way to combine all values of 2017 and 2018 into one column for each year? "Combine" means that I want to sum all values from a field into one column, so for (e.g.) 2017, it should be 7 (=5+2).
Note: I'd prefer to not Use the Charts API, but I will if I have to.