G
gilly3
I have a pivottable that looks something like this:
Date
ID 5/1/04 5/2/04 5/3/04 5/4/04
1 (data) (data) (data) (data)
2 (data) (data) (data) (data)
3 (data) (data) (data) (data)
4 (data) (data) (data) (data)
I'd like to modify it to look more like this:
Date
Fruit 5/1/04 5/2/04 5/3/04 5/4/04
apples (data) (data) (data) (data)
bananas (data) (data) (data) (data)
oranges (data) (data) (data) (data)
grapes (data) (data) (data) (data)
I'm not sure this is possible, but I'm optimistic. How would I change the
"1" to "apple", and so on?
You are probably thinking, "why not just return it that way from the
database?" Well, I've got a stubborn DBA who is telling me it will be too
tricky to add that kind of data to the database. Whatever.
Anyway, is this possible?
thanks
-ivan.
Date
ID 5/1/04 5/2/04 5/3/04 5/4/04
1 (data) (data) (data) (data)
2 (data) (data) (data) (data)
3 (data) (data) (data) (data)
4 (data) (data) (data) (data)
I'd like to modify it to look more like this:
Date
Fruit 5/1/04 5/2/04 5/3/04 5/4/04
apples (data) (data) (data) (data)
bananas (data) (data) (data) (data)
oranges (data) (data) (data) (data)
grapes (data) (data) (data) (data)
I'm not sure this is possible, but I'm optimistic. How would I change the
"1" to "apple", and so on?
You are probably thinking, "why not just return it that way from the
database?" Well, I've got a stubborn DBA who is telling me it will be too
tricky to add that kind of data to the database. Whatever.
Anyway, is this possible?
thanks
-ivan.