Using formulas show the ranking wise top products qty month and status wise

[Chinnavenky]

Ex:- the below mentioned is the data required top poducts qty sales in month & Status wise like pivot table

Month Status Product QTY Value
Jan positive Product1 34 281
Feb negative Product2 48 281
Mar positive Product3 51 341
Jan negative Product4 60 236
Feb positive Product5 17 156
Mar negative Product1 33 382
Jan positive Product2 29 140
Feb negative Product8 48 231
Mar positive Product9 33 264
Jan negative Product10 28 143
Feb positive Product11 12 273
Mar negative Product12 26 375
Jan positive Product1 25 344
Feb negative Product2 47 186
Mar positive Product15 27 336
Jan negative Product16 51 261
Feb positive Product1 38 373
Mar negative Product2 30 204


The below mentioned is the pivot table

In pivot table filter field
Month Jan
Status positive

In pivot table Row field In pivot table Value field
Row Labels Sum of QTY Sum of Value
Product1 59 625
Product2 29 140
Grand Total 88 765






Required data By using formulas
Month Jan
Status Positive
Top 5 Product Qty Value
1
2
3
4
5

[AliGW]

Welcome to the forums!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Chinnavenky]

please find the attached file

[samba_ravi]

i4=

Please Login or Register  to view this content.

k4=

Please Login or Register  to view this content.

j4=

Please Login or Register  to view this content.

try this and copy towards down