selection and SUM(TOTAL <item> Column)

[amien]

i have this pivot:

dimensions: department, team, user

expression:

SUM(Value)

SUM(TOTAL <user> Value)

This is all good when i make no selection .. but when ik make a selection in team from a listbox..

first expression is fine .. second expression have the same value as the first expression.

how can i make the second value be the same when there is a team selected .. or no team selected.

Thanks in advanced

[disqr_rm]

Look into aggr().

[amien]

can you please give an example please:

dimension: team, bucket

expression: SUM(value)

i want to keep the Sum(Value) based on the team and bucket, even when a user is selected. or any other selection is done