I seek your expert knowledge to overcome my issue!. In fact Mr Vishwanath, Ranathunga helped me towards this to some way. I may again present you the case.
I have a requirement to get the higher approval for expenses which have been exceeded the budgetary allowances! This I have to do quarterly. Easily I may arrange the 1st Table with lots of expressions basically actual & the budget.(Need to consider the cumulative). For the reasons for each exceeded expenses I have to go through the list & find out. Once I arranged that I may arrange them in a table (2nd table). Here as you can see some reasons are there for all the Branch codes & for other may be 1st or 2nd . My requirement is as follows!.
Pick those reasons to be appeared before appear each expenses items which are having negative cumulative variance!
If I use the Concat, it seems all the reasons are linked to all Branches.
Since many Branches are involved, I cannot do this for individual Branches if so actually no issue because I can pick reasons from separate table arranged for that particular Branch & so on. But this is very long process. Hence please advice, help me to achieve this.
Each Branch should pick the relevant reasons highlighted in the reason table
There are two common field such as BR_CODE & TYPE,
