URGENT: Text as a Measures column

J

josh

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 ;-(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top