Hi All,
I have a doubt in set analysis for calculating sum of previous month sales. The calculation is based on 5 columns
The expression i wrote in calculation is:
SET Shared.Calculation.SOHValueMonth='SUM({<[FISCAL YEAR]={$1},[FISCAL MONTH]={$2}>} +-++)';
and calling this calculation in expression as:
=NUM($(Shared.Calculation.SOHValueMonth($(=[FISCAL YEAR]),$(Shared.Calculation.CurrentFiscalMonth)-1)), Shared.Format.MoneyRound)
Please let me know if my approach is right.... Thanks in advance.