Time comparison

[narayanamsn]

@@Hi Gurus,

I have an example with dummy sales data where in  i need to plot time series Quarterly sales comparison.

I want to derive comparison table that holds the sales with max quarters for each combination.

This table should change the values if I select any Quarter accordingly

@Vishwarath Nagarau vnagaraju‌

stalwar1    

Company	Route	Max Qtr	Pre Qtr	Same Qtr Last Yr	Q/Q	Y/Y
A	Retail	180	-	300	=(180 -0 )/0	=(180 -300 )/300
A	wholesale	200	150	290	=(200 - 150 )/150	=(200 - 290 )/290
	Total	380	150	590	=(380 - 150 )/150	=(380 - 590 )/590
B	Retail	120	-	150	=(120 - 0 )/0	=(120 - 150 )/150
B	wholesale	200	150	180	=(200 - 150 )/150	=(200 - 180 )/180
	Total	320	150	330	=(320-150)/150	=(320 - 330)/330

[vishsaggi]

Can you tell me Max Qtr for Retail and Wholesale is 180 and 200? I mean which year? Do you select in year too? Is the above sample data you posted is your expected data?

[narayanamsn]

Hi Vishwarath,

you are correct. Max Qtr is for Max Year. I am expecting the same table that i added

[sunny_talwar]

What you have listed above is the expected output you are looking to get?

[sunny_talwar]

This?

[narayanamsn]

Yes Sunny

[narayanamsn]

will you be able to share the QVW?

[sunny_talwar]

Great, I have attached the qvw to my response above... you can see how to do it

[sunny_talwar]

Open this link for th qvw

Re: Time comparison

[vishsaggi]

Sunny Just wondering can we also write like this?

= Max({<Qtr, FYQTR, YearMonth = {"$(=Max(YearMonth,2))"}>}Sales)
//Sum({<YearMonth = {"$(=Max({<Qtr, FYQTR, YearMonth = {[$(='<=' & Max(YearMonth))]}>}YearMonth, 2))"}, Qtr, FYQTR>}Sales)

I get the same results though wanted to know the usage of YearMonth = {[$(='<=' & Max(YearMonth))]}>}?