How to create dynamic comparison table with trend , based on prior period rank ?

[shekhar_analyti]

Hi All ,

How to create dynamic comparison table with trend , based on prior period rank ?

Data Input

Year-Qtr	Stakeholder	Location	Strike_Intensity_Rank
2016-Q1	Chromite Inc.	Frankfurt	6
2016-Q2	Falcon Sphere	Lisbon	4
2016-Q3	Drome Lui and CO.	Seol	8
2016-Q4	A&A Confectionary	Sychelles	8
2016-Q1	Chromite Inc.	-	5
2016-Q2	Falcon Sphere	-	6
2016-Q3	Drome Lui and CO.	-	8
2016-Q4	A&A Confectionary	-	3
2017-Q1	Chromite Inc.	Frankfurt	2
2017-Q2	Falcon Sphere	Lisbon	7
2017-Q3	Drome Lui and CO.	Seol	3
2017-Q4	A&A Confectionary	Sychelles	8
2017-Q1	Chromite Inc.	-	8
2017-Q2	Warton Engineering	-	8
2017-Q3	Drome Lui and CO.	-	4
2017-Q4	A&A Confectionary	-	9
2018-Q1	Chromite Inc.	Frankfurt	9
2018-Q2	Falcon Sphere	Lisbon	6
2018-Q3	Drome Lui and CO.	Seol	4
2018-Q4	A&A Confectionary	Sychelles	1
2018-Q1	Chromite Inc.	-	6
2018-Q2	Falcon Sphere	-	7

OUPUT : When Default Period Range = 1

Default period Range

Thanks & Regards

Shekar

[shekhar_analyti]

Hi Sunny Bhai , stalwar1‌

Please help .

[sunny_talwar]

Why is default view for 2017 and not 2018?

[shekhar_analyti]

2018 is the current year and in real time for 2018 we dont have data for its q3 and q4 . But for sake of testing i addded Q3 - O4 data in 2018 .

[sunny_talwar]

So, default will be always one year before the current year?

[shekhar_analyti]

Yes

[sunny_talwar]

Check the attached

[shekhar_analyti]

Thank You Sunny Bhai .... But default period range functionality is not there .

[sunny_talwar]

What are you seeing, not this?

[shekhar_analyti]

Also ,

Location -= {'-'} . Actually "-" was referred for highlighting null values