Set analysis issue for quarter

[#1]

Hi,

i have req like to show sum(sales) of Q1 last month to Q4  in the previous year 2nd month.

regards

Mahesh Thalluri

[#2]

CAn you explain more details about your problem?

[#3]

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

[#4]

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

[preminqlik]

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 .....

[#6]

I hope the below discussion will help you:

Set Analysis - Quarter over Quarter Comparison

Thanks,

Angad

[manojkulkarni]

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)...