Question on straight table selection

[ramanarayan]

Hi Experts,

I have a list box with Qtr as field and a straight table for sales amount.  

By default, i have customized the straight table to show 3 quarters from the latest quarter when no selection is made.

However, what i need is, when i manually select any quarter from the list box, i need to be able to see the selected quarter + previous 2 quarters as well. 

Need an expression to achieve this please.

Attached is my qvw file.

[sunny_talwar]

I am not seeing any qvw file attached? Did you forget to attach?

[ramanarayan]

sorry i missed. Attached now

[sohailansari201]

Please see if this helps you. (QVW Attached)

[bharani8]

What does Rnk field do here? and on wat basis did u segregate that? Can u plz explain..

[sohailansari201]

Rnk is a simple serial number that starts from 1 for the latest Quarter. This is used in the variables to figure out previous two Quarters. For e.g. if latest Quarter is Q4-2018, then using Rnk 2 and 3, we immediately know that previous two Quarters are Q3-2018 and Q2-2018. Similarly, when user click on any quarter from the list box we get it's Rnk value and then add +1 and +2 to get the previous two quarters. If you look at the variable definitions, it should become more clear. Thank you.