Not applicable
2015-01-27
09:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pivot table - minimum value at columns
Hi,
I've the following pivot table:
Group | Grades | 90 | 80 | 70 | 60 |
A | 42 | 50 | 55 | 57 | |
B | 15 | 18 | 10 | 19 | |
C | 22 | 10 | 15 | ||
D | 10 | 8 |
I want the following output:
for each row to place at the cells the min value
Any idea?
Thanks.
602 Views
1 Solution
Accepted Solutions
sunny_talwar
MVP
2015-01-27
10:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
491 Views
3 Replies
sunny_talwar
MVP
2015-01-27
10:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
PFA, This is not exact, but close to what you want.
Best,
S
491 Views
sunny_talwar
MVP
2015-01-27
10:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is exactly what you wanted.
Best,
S
492 Views
Not applicable
2015-01-27
10:29 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Amazing
491 Views