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.

[#2]

sorry you say in this example ' D, E F selections are not consider and A,B,C dimensions are not considered.'.  Which ones will be considered?

[#3]

thats worked.

Can i apply the same principle to this: count( distinct JoinKey)

[morganaaron]

Yes - most functional expressions (max, min, count, sum etc.) you can apply set analysis to, and so within that you can exclude fields from the set like shown - same goes with the total qualifier!

[#5]

okay I tried it but i think I may have my syntax wrong.  COuld you give me an example with my count( distinct JoinKey) please

[jagan]

Hi,

Can you attach some sample data and your required output?  It would be easier and understand and give solution.

Regards,

jagan.

[#7]

so pretty  much want to do the same as the other example (which works) but now on another expression which is currently set at:  count( distinct JoinKey).  So in this example, I would want it to not apply to dimensions E, F  but apply A, B, C, D.

[#8]

can i post the example QVW if you could take a look at?

[morganaaron]

Go for it.

[#10]

this is the expression I have but it is showing as incorrect syntax.

count({distinct JoinKey}),{[Expense Code Description]=, CostCentreDescription2=, CostCentreDescription3=, CostAnalysisDescription=, CostClassificationDescription=>

[ashwanin]

Try below

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