Hi,
I have asked this in a previous post and not had any replies, I did attach my full documrnt which i might of been abit confussing so i've simplifed it below:
I have a table that has Data on a monthly basis and a flag to say wheather it should be green or red.
In my table I have a minchart to get the trend of data. My problem is that if I just want to see for example all the reds in Feb, the data returns every row that has a red at somepoint in the year because of the minichart.
Basically I just want to see Reds for Feb and have trend for measures.
Hope this makes sesnse, i've attached an example.
THank you in advance
