Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have req like to show sum(sales) of Q1 last month to Q4 in the previous year 2nd month.
regards
Mahesh Thalluri
CAn you explain more details about your problem?
I'm not sure what you want to do, but it still looks like a perfect candidate for SET ANALYSIS.
Can you upload some example/post some data?
Lukasz
Sum(sales) range should be Q1 's last month in current year suppose in 2014 -march and Q3 last month suppose in 2013 September here in expression u have to add quarters as well for data.
regards
Mahesh
i think according to your req , u have to caclulate last
months of current quarter ( Q1-2014) and last month of previous quarter (Q3-2013) ...didn't get you exactly what you mean...make excel and share results in that .....
I hope the below discussion will help you:
Set Analysis - Quarter over Quarter Comparison
Thanks,
Angad
as per your requirement, I think you are looking something like last 3 qtrs sales. Each qtr sales will be the sales for the last month of qtr. eg : Q1-2014 (March'14), Q4-2013(Dec'13) & Q3-2013(Sep'13)...