custom sum in crosstab

[avuong6]

i tried pulling the measure into the column. it said i couldnt put it there.

i tried referencing the item from the package. issue there is i cant get to the package. when i select the source icon of available components, i only see the join of category config trans and trans querys.

why would it behave like this?

[avuong6]

so i figured out why its not totaling for the 'total' column.

total:  total([Trans].[TRANS_VALUE] for [TRN_TYPE_SCH],[QUARTER],[CATEGORY_NAME])

my column subtotals are not considered part of category_name or quarter or trn_type_sch

foreign affilitiates:  if ([CATEGORY_NAME] = 'Foreign Affiliates') then ([Trans].[TRANS_VALUE]) else (0)
unaffiliated foreign persons:  if ([CATEGORY_NAME] = 'Unaffiliated Foreign Persons') then ([Trans].[TRANS_VALUE]) else (0)

when it gets to these row, the total definition doesnt apply to foreign affilitiates and unaffiliated foreign persons.

how to rewrite total so it sums up for what ever is in the rows?

[avuong6]

just wanted to update on the resolution. the total wasnt working because the formula only applied to member of the category and the custom totals were not members. so to make it work i created a total data set and unioned it with the original set.