Using a Variable in Set Analysis

[#1]

Hi,

Can someone help me with this pelase?

I have been working on a complex dashboard, and couldn't get a variable working in Set Analysis. I have done in the past, but for some reason this particualr one does not seem to work and I can work out why.

I've attached the example below.

I've got 2 table one I have manualy entered the value in the set analysis and the other I'm trying to get it from a Variable.

It works in one table but no the other.

Can some help please.

Cheers

Simon

[Anonymous]

You got it almost right.  This works for me:

Sum ( {<MonthYear={'$(vMonth)'}>}  Data)