Hi,
I've a problem that I think can resolve with set analysis but I don't know.
I have two fields [MES ACTUAL] and [NOMBRE MES ACTUAL] which are months and his name and a column [MESES] with this expression: COUNT([NOMBRE MES ACTUAL])
It gives me the number of months filtering in [NOMBRE MES ACTUAL]. This is correct but I need to add new funcionality.
Now I have a new field [MES SUELDO] which are months between two dates. I need to count [NOMBRE MES ACTUAL] are filtering but only for [MES SUELDO]=[MES ACTUAL]. I try: COUNT({<[MES SUELDO]=[MES ACTUAL]>}[NOMBRE MES ACTUAL]) but it don't works.
I attached a graphical explanation.
Thank you very much,
O.Iglesias.
