I need urgent help to replace a pivot that I have created for reporting
The data sheet has more than 20,000 rows and 65 columns. The main information forming this reports come from 4 columns - e.g Classification, Sub Classification, Category & Count
Report needs to populate Top 5 Records from each subclassification with Category name and Count
e.g.
Classification Sub Classification Category Count
Apple Golden Delicious Fresh 50,000
2days-old 23,000
Week-old 20,000
Unclassified 10,000
Pink Lady 2days-old 30,000
Week-old 20,000
Fresh 2,000
Unclassified 10,000
Orange Navel Fresh 45,000
2days-old 32,000
Week-old 20,000
..... & so on
The formula is required to populate top 5 records at the right. The classification and Subclassification can remain fixed in the report table in a new Tab as that would not change quite often, hence the formula to populate Column 3 & 4 in the example above is desparately needed.
Any Help is really apprecaited.
The data sheet has more than 20,000 rows and 65 columns. The main information forming this reports come from 4 columns - e.g Classification, Sub Classification, Category & Count
Report needs to populate Top 5 Records from each subclassification with Category name and Count
e.g.
Classification Sub Classification Category Count
Apple Golden Delicious Fresh 50,000
2days-old 23,000
Week-old 20,000
Unclassified 10,000
Pink Lady 2days-old 30,000
Week-old 20,000
Fresh 2,000
Unclassified 10,000
Orange Navel Fresh 45,000
2days-old 32,000
Week-old 20,000
..... & so on
The formula is required to populate top 5 records at the right. The classification and Subclassification can remain fixed in the report table in a new Tab as that would not change quite often, hence the formula to populate Column 3 & 4 in the example above is desparately needed.
Any Help is really apprecaited.