Hello,
I have a Table where I have to calculate per month a expression based on different date.
The dimension:
=AQMP.MONTH
The expression:
count(DISTINCT {<AQMP.YEAR={$(=Max(AQMP.YEAR))}, AQMP.MONTH={"<=$(=Max(AQMP.MONTH))"}>} [AQMP.N° AQMP])
/
count(DISTINCT {<AQMP.YEAR=, AQMP.MONTH=, TSF.YEAR={$(=Max(AQMP.YEAR))}, TSF.MONTH={"$(=only(AQMP.MOIS))"}>} TSF.Product)
In the second calculation I need to calculate for each month from the dimension the TSF.Product. And the Table TSF doesn't have the same calendar. And it must be aggregate per month from dimension AQMP.MONTH