I'm using Excel 2007 to query a cube in SSAS.
I need to get the total of a measure, for a subset of Dimension members.
Say that the measure is TotalSales, and there's a Salesman dimension with 3 members :Fred, George and Jim.
I need the combined total sales for Fred and George .
The function for getting the total sales for one salesman is:-
But when I try to add another salesman, I get #NA
Can anyone help?