Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
sorry i missed. Attached now
Please see if this helps you. (QVW Attached)
What does Rnk field do here? and on wat basis did u segregate that? Can u plz explain..
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.