Ok...here is the scenario...

I have a dimension named [Dim KPI]

Within the dimension I have two members - [KPI Name] and [KPI Type]
[KPI Name] stores the name of the KPI we are looking at
[KPI TYPE] stores the type of the KPI - values are "$", "%",
"A", "#"

Measure named [KPI Actual] that stores the value for each [KPI Name]

I am writing against DSP (www.dspanel.com) webparts. The table webpart
only allows me to place one column on each row/column.

My situation is that I need to average the [KPI Name] if the KPI Type
is "A". So really what I need to do inside of a calculated member
is reference another member inside of the dimension, but I can't use
KPI Type as part of the pivot table

I have tried various membervalue / Properties expressions but I
can't seem to come up with anything.

Some help here would be greatly appreciated! I am at my wits end on
this one.

Thanks!

Dave