Post the workbook. I want to play with it.
i figured it out. If yo combine to fields manually, meaning select 2 dimensions, right click, select transform, then "combine fields" you CANT use them in a calculation. to use 2 combined dimensions, you must create a calculated field using
this will be available to you in Table Calculations