Get sums of different columns of another table

[mallika]

This is very similar to this thread - Referencing Column Name from another table

The SwitchIf statement works or you can restructure your table and use Lookups.