Hi,
I want to ask you for an advice.
I've got report, where I calculate some measures within periodsToDate set.
Like this:
-----------
<code>
total ([Revenue] within set [YTD_period])
/
total ([Opportunity] within set [YTD_period])
</code>
Where set expression looks like:
-----------
<code>
periodsToDate ([GSPT_Cube_Danzsale].[Period].[Period (All)].[Year],[GSPT_Cube_Danzsale].[Period].[Period (All)]->?p_period?)
</code>
In the same query, I'm showing the values for the whole previous year:
-----------
<code>
children (prevMember (parent([GSPT_Cube_Forwin_Mix_Country].[Period].[Period (All)]->?p_period?)))
</code> as [PY_period]
It's all good, when I want to show year to date values of the sets members thanks to Total function, but my problem is to count the measure for each member of the sets "separately" to show monthly values in the sets.
Do you have any ideas please?
Thanks,
Martin