I'm trying to create a chart that shows a calculated information but I'm not getting what I want, so I need some tips.
I have a table with information consolidated at the month level. So, when I'm exibiting the information at the higher level (Year) it consolidates the information (SUM), but I need for that only the last month of the year. How can I do it? I'm trying to implement it on a bar chart.
Values for 2015
Values for 2016
Year (Higher Level):
What I need to show when in year level (Last value for the last month of that year):