ST Alpha - "here is an excel question" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 162

here is an excel question

Posted by workmanda (aka amanda) Aug 18 '10, 10:18

I have a pivot table. I am pasting here. one fifth of it here (I have an almost-identical list for each campus). sorry for the formatting.

I would like excel to tell me the % of the concord total, for instance, that 3102's 4300 is. I know I can do that, but I forget how. I can't anchor the $71800 and drag down because it's pivot output.

thanks so much.

also, when I go into output options and say "show as percent," I can't make the "percent of what?" field show the concord total, just the five campus total. see?

Concord $71,800
3102 $4,300
3202 $18,300
3203 $4,000
3502 $4,000
3503 $2,300
3602 $2,000
3605 $14,000
0000 $22,900

Responses:

This should point you in the right direction - Will Hunting Aug 18, 10:21 3 1
- oooh...shiny -- nm - znufrii Aug 18, 10:29
- oh, thats noice. good find. -- nm - TFox Aug 18, 10:24 1
  - Yeah, pivots are my weakest thing in excel so this is pretty good for what I'll need. -- nm - Will Hunting Aug 18, 10:33
I don't do pivots but in regular sheets you would refer to it as A$2 to anchor the row number. -- nm - zork Aug 18, 10:21
you want that info in the pivot table, or off to the side? =a2/$a$1 formatted as a % will get you there in 2 seconds off to the side. -- nm - TFox Aug 18, 10:20 3
- right, if I could use A1 as the cell ref. it won't let me because it's pivot output. -- nm - workmanda Aug 18, 10:21 2
  - oh, its forcing you to getpivotdata lookups when you click? you should be able to get around that by just typing the reference. - TFox Aug 18, 10:23
  - screwit. I pasted the pivot output so I can use the data as I need. ha ha, bill gates. -- nm - workmanda Aug 18, 10:22

Post a message top

here is an excel question

Replies are disabled on threads older than 7 days.