One chart with filter date range and another one with the last month of filter date range

[marcodelgrosso]

Hey,

I've two charts, the first one displays the values about filter date range (I did it), but the second one is a barchart that has to refer only to the last month of filter date range. How can I do that?

As in the following example: the filter  range date is Feb 22 to May 22 but the barchart has to display the sum of data about only May 22.

[MartW · Accepted solution]

This is quite easy, you need some set analysis within the barchart (meassures)

I don't know the field you use in you meassure and how the month name is but the set analysis would be something like this

Sum ( { <  Monthfield= {"$(=max(Monthfield))"} > } Measure field)

[marcodelgrosso]

Perfect solution! It works such as I wanted to.

Thank you so much