Hi,
I have a scenario where for one of my calculation, my Fiscal year value as to be sum of all the months i.e. supposedly my fiscal year starts in Nov, FY 2014 will be Nov 2013 value + Dec 2013 value + jan 2014 value+...+ Oct 2014 value.
I have mocked up the below scenario so in this case "sheet 1" FY 2014 value for ratio should be 130 instead of 11 and FY 2015 should be 75 instead of 8.
Can anyone tell me how to do it..?Please use version 10.3 or lower versions.
Thanks in advance!
Hi Kahv,
It could be
{INCLUDE DATETRUNC('month', [Order Date]) : SUM([Sales])/SUM([Profit])}
with the Default Aggregation to be SUM()
Yours,
Yuri