How To Access List Of Visible Measures On A Pivot Table

[David]

Does anyone know how to access a list of the measures currently on a pivot
table?

Current, this does not work for me:


function listColumns(){
var returnValue="";
var pivotField;

//next line returns zero for the count even
//though there is data visible
alert("PT.ActiveView.DataAxis.FieldSets.Count=" +
PT.ActiveView.DataAxis.FieldSets.Count);
for(var x=1;x<=PT.ActiveView.DataAxis.Fields.Count;x++){
alert(PT.ActiveView.DataAxis.Fields(x).Name);
if (returnValue!="") returnValue+=", "
returnValue+="\"" + PT.ActiveView.DataAxis.Fields(x).Name + "\"";
}
return returnValue;
}