M
Michael Barrett
Hi,
I have a pivot table using data from Microsoft Analysis Services. I need to
reference the table using the GETPIVOTDATA() worksheet function. The pivot
table contains one data field and two dimensions. In order to retrieve the
data field I need to reference both of the dimensions. One of the dimensions
I will reference with the member name, but the other one needs to be
referenced by one of the member properties of the member rather than the
member name. Is this possible?
I have a pivot table using data from Microsoft Analysis Services. I need to
reference the table using the GETPIVOTDATA() worksheet function. The pivot
table contains one data field and two dimensions. In order to retrieve the
data field I need to reference both of the dimensions. One of the dimensions
I will reference with the member name, but the other one needs to be
referenced by one of the member properties of the member rather than the
member name. Is this possible?