Hello:
Please refer to attached file.
I have monthly receipt data as shown in column A thru E when Column A is the month, B is the Store Name, C is Desc,D is Qty and E is the amount of sales
I need to use Pivot table to give the result as shown in column J & K
Let me know if you have any questions.
Thanks.
Riz
Can't you just use filter?
See attached.
Other than that, to make things easier, you can add helper column to original table for filtering flag (using match or some other function depending on your actual workbook set up).
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Its easy to pivot and then you can filter the row labels to just display the values you want, however the results will be in alphabetical order, not the order you specified if that's important
if the order is important in J6 put =SUMIFS(E:E,$A:$A,J$4,$C:$C,$I5)
You might also simply drag them into the desired order in a pivot table.
Don
Please remember to mark your thread 'Solved' when appropriate.
Enter in J5 and copy across and down
Formula:
Please Login or Register to view this content.
OR
Formula:Please Login or Register to view this content.
Last edited by AlKey; 11-08-2017 at 11:17 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hello:
I believe Alkey solution would be the easy to implement.
Thanks to all.
Riz
Hello Alkey:
I have tried in my own sheet and i am getting error..
Please have a look at attached pic
Please let me know if you have any questions.
Thanks.
Riz
Can you upload this spreadsheet instead of picture?
Hello Alkey:
Please refer to attached file.
Let me know if you have any questions.
Thanks.
Riz
Enter in G5 and copy across to R5 and down
Formula:Please Login or Register to view this content.
...It will also work without TEXT function:
Formula:Please Login or Register to view this content.
Last edited by AlKey; 11-08-2017 at 12:57 PM.
Hello Alkey:
Superb help....You are the master in formula.
Thanks a lot
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks