Reg 2 Months in One Report?

[#1]

HI All,

Please find the screen shot how my data was looking :

I  want the O/p as:

Month         Product       Value

Feb            Humira         Reporting Month (March) / Month (February)

[#2]

Load the data and create a chart as below,

Dim : Month , Product

Exp : sum({<ReportMonth={'MAR'}>}[In-Market Units])/sum({<ReportMonth={'FEB'}>}[In-Market Units])

Regards,

Prabhu

[#3]

like this i am having all months, how i can write..

[daveamz · Accepted solution]

Hi Helen,

See the file attached. I solve it in 2 ways: in first one I calculated within the script and needs some sorting, grouping. In the second one I used if...

In any case it will be a good practice to replace MONTH values (FEB, MAR) with numeral correspondent (01,02 or even better 201402, 201403) because of the sorting.

Regards,

David