Just found this group thought it would be better suited here...

Is it possible to have text in the "measures" area of the pivot table?


For example: I have a report that list sales people on the left and
their sales totals for the month in the measures section.
I have a need to show which state a sales person works in (I created a
dimenstion of this data) on the same chart. I have added it as a
filter but there is know indication anywhere in the chart who belongs
to which state. I do have it setup so that if you hover over the
person's name it will give you some more info but it is not readily
available...


Is there anyway to accomplish this, if not I will not be able to use
the OWC ;-(

I've come across the same problem recently. The only known way to me (as
recommended by Keith) is to use calculated cells to display 'text' into a
measure field. Using this method will probably solve your problem but if
you're using any version other than SQL2k Enterprise, than you're out of
luck since the other versions doesn't support calculated cells in AS.

Alternatively, you can try some other workarounds like using drilldowns or
tooltips.....



"aa7im" <josh (AT) nautilusnet (DOT) com> wrote

Wow! Unfortuantely I don't have SQL2k Enterprise readily (I can get it
if I have to however)....


Is there really no other way? Any other ideas? Are the tooltips the
only way to show other info?


This is become extrememly urgent for me so if anyone has any solutions
at all (no matter how strange) I would love to here from you....
Thanks!

Calculated measures (standard feature) can contain text:

http://groups-beta.google.com/group/...rver.olap/msg/
18d1183adc7f37bf

You can use calculated measures to show any text you want. We are
using this feature even to show images in the grid, like:

iif(measure >100%, "<img src=\images\good.gif>" , "<img
src=\images\bad.gif>")
...

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!