Get latest Month and Quarter in Cross Table

[Manjunath Jannu]

Hi Spotifre experties and Dr Spotfire.

I have requirment.

If Dec-19 is selected, The below data will be show in Cross Table

Company A :- May19-----latest data

Company B :- Dec-19

Company C :- Mar-19

Company D :- Sep-19

Note : Most recent data i wanted show in table, for example ihave selected DEC-19 and i dont have data for DEC it should show recent data like MAY-19 as per below table

Please let me any idea or how limit using expressionwill be grate help

 

 

 

 

2019Q1

2019Q2

2019Q3

2019Q4

 

 

Company

Jan-19

Feb-19

Mar-19

Apr-16

May-19

Jun-19

Jul-19

Aug-19

Sep-19

Oct-19

Nov-19

Dec-19

 

 

Co. A

 

 

 

 

A

 

 

 

 

 

 

 

 

 

Co. B

 

 

 

 

 

 

 

 

 

 

 

B

 

 

Co. C

 

 

C

 

 

 

 

 

 

 

 

 

 

 

Co. D

 

 

 

 

 

 

 

 

D