My problem here is that we only actually want to show the total count of target clients from 12 months before to the end of the selected month(s). As I have to show the months in the table, its been agreed that its ok to have the total target the same if there are multiple months selected (and therefore shown in the table). However, I can't get the total the same over two or more months! In my example below, the total expected is shown in November. But if the client hasn't purchased in December, they are not counted in the December count. I tried to add a < today's date variable which is set based on the latest month selected, but that doesn't cut it. Any ideas ?
Expression 2 : A separate count by month.
So in the example here, I'd like to have the DN Clients Cible be the same in both November and December. Or magically change qlikview so that I can only show this expression in the Total. 😉