ytd and previous ytd

[kalyani9]

Hi all

I have report from dimensional model. For example



rows---> productline

measure ---->revenue

columns----> ytd and previous ytd



I have prompts for year and month.I need to calculate ytd and previous ytd.



Thank u in advance



Regards

Kumar

 

[jjb373]

The following is something you can consider to get yourself started...

Say your Prompt values for year and month is as follows:

PromptYear()
PromptMonth()

Then you may be able to create calculations similar to this:

Your YTD would be: Add-Years(PromptYear(), -1)

Your Previous YTD would be:
Between Add-Years(PromptYear(), -2) and Add-Years(PromptYear(), -1)



-- JJB373 --