Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
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
like this i am having all months, how i can write..
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