I need to make a bar / line chart, which groups the last 12 months of the year, and shows me in bars, the sum of each of the columns.
Source of dates:
Expected type of graph:
X-AXIS: There are no problems here. Using the following, I manage to group by month, the last 12 months of the year:
SERIES: Here comes the problem: if I do the following, I add (count) the number of rows in column A. This logically, is not what I wanted, but it gives me the idea, that the Lookup works well.
If in the "countdistinct" I change column A, for column C (which would be expected) I don't get results.
I am sure that the problem is in the COUNTDISTINTC, but I could not solve it, so that I can add all the values in column C, grouped by month.
Can someone help me with this?