Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Pivot Table with calculations to identify product (A,B,C) rankings.
I would like to have a summary table saying how many products have A assigned, B assigned,...and so on. Example below.
Is this possible?
LARGE TABLE
| Style_Desc | PH3 - Gender | PH5 - Classification | Times Ave | Ranking |
| Product 27 | WOMENS | SS Tee | 3.8 | A+ |
| Product 28 | WOMENS | SS Tee | 3.8 | A+ |
| Product 29 | WOMENS | SS Tee | 3.3 | A+ |
| Product 30 | WOMENS | SS Tee | 3.1 | A+ |
| Product 31 | WOMENS | SS Tee | 2.9 | A |
| Product 32 | WOMENS | SS Tee | 2.8 | A |
| Product 33 | WOMENS | SS Tee | 2.7 | A |
| Product 34 | WOMENS | SS Tee | 2.7 | A |
| Product 35 | WOMENS | SS Tee | 2.5 | A |
| Product 36 | WOMENS | SS Tee | 2.4 | A |
| Product 37 | WOMENS | SS Tee | 2.4 | A |
| Product 38 | WOMENS | SS Tee | 2.4 | A |
| Product 39 | WOMENS | SS Tee | 2.3 | A |
| Product 40 | WOMENS | SS Tee | 2.2 | A |
| Product 41 | WOMENS | SS Tee | 2.1 | A |
| Product 42 | WOMENS | SS Tee | 1.9 | B |
| Product 43 | WOMENS | SS Tee | 1.9 | B |
| Product 44 | WOMENS | SS Tee | 1.5 | B |
| Product 45 | WOMENS | SS Tee | 1.5 | B |
| Product 46 | WOMENS | SS Tee | 1.2 | B |
| Product 47 | WOMENS | SS Tee | 1.2 | B |
| Product 48 | WOMENS | SS Tee | 1.2 | B |
| Product 49 | WOMENS | SS Tee | 1.0 | B |
| Product 50 | WOMENS | SS Tee | 1.0 | B |
| Product 51 | WOMENS | SS Tee | 0.9 | C |
| Product 52 | WOMENS | SS Tee | 0.9 | C |
| Product 53 | WOMENS | SS Tee | 0.9 | C |
| Product 54 | WOMENS | SS Tee | 0.9 | C |
| Product 62 | WOMENS | SS Tee | 0.7 | C |
| Product 63 | WOMENS | SS Tee | 0.7 | C |
| Product 64 | WOMENS | SS Tee | 0.7 | C |
| Product 65 | WOMENS | SS Tee | 0.7 | C |
| Product 66 | WOMENS | SS Tee | 0.6 | C |
| Product 67 | WOMENS | SS Tee | 0.6 | C |
| Product 68 | WOMENS | SS Tee | 0.6 | C |
| Product 69 | WOMENS | SS Tee | 0.5 | C |
| Product 70 | WOMENS | SS Tee | 0.5 | D |
| Product 71 | WOMENS | SS Tee | 0.4 | D |
| Product 72 | WOMENS | SS Tee | 0.4 | D |
| Product 73 | WOMENS | SS Tee | 0.4 | D |
| Product 74 | WOMENS | SS Tee | 0.4 | D |
| Product 75 | WOMENS | SS Tee | 0.4 | D |
SUMMARY TABLE DESIRED
Rank Product Count
A+ 4
A 11
B ...
C
D
Please find the attached file.
The Rank is a calculated field that changes based on the Times Average value. In the example it looks like the Rank is a static value. Is a summary table still possible?