Aggregation to different levels

[#1]

Hi

I a sheet in my QV that has several dimensions and three measures.  I want to be able to aggregate two of the measures to a set of dimensions and the one measure to another set.  So for example I have dimensions

A

B

C

D

E

F

and measures 1,2 3. 

I want measure 1 to work across all dimensions and measures 2 and 3 to work across only A, B, C.  So if lets say the user selects something from dimension F measures 2 and 3 should not aggregate to to that level.

[morganaaron]

You need the field at the end of the expression, and you've got a few {'s in the wrong place:

Count({<[Expense Code Description=, CostCentreDescription2=, CostCentreDescription3=, CostAnalysisDescription=, CostClassificationDescription=>} Distinct JoinKey)

[#3]

thank you very much for your help.  This has worked.