Hi everyone,
I'm trying to creat a pivot table that needs to have linked/mandatory fields,
I'm giving you an example: if we go to a website to fill in our details, and we insert the country, it will automatically give us one of three options, cardinal points, state and town, and you're obliged to choose one of every those options, what i need to do is actually that.
my fields are: Name, Amount, Type of financial instrument, Payment %, Credit line, Bank
my options: XXX, 100 000$, LC, 4%,5%, 6%,, YES/NO, BNP/BARCLAYS/BOFA then how do I make it in a way, that all the clients that are on the 100.000 racio, are taken immediatly to the 5% option if they choose BOFA, or to the 6% if they chose BNP or Barclays?
Or if they want to choose the option, by the amount they will pay how can then they be sent to the mandatory corresponding bank options?
Thanks everyone
Bookmarks