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?