Help on creating a summary

**Julyexcel124** · 11-25-2020, 05:42 PM

Hi ,
I have data as attached in excel and would like to have a summary in the following format :

Group Product day1 Product day 2
Correct. Incorrect Correct. Incorrect
XYZ 2 0. 1. 0
Aaa. 1. 1. 2. 1
Yyy. 3 1. 3. 1

Or

Group Product day 1. Product day 2
XYZ
Correct 5. 2
Incorrect 1. 0
Aaa
Correct 4 5
Incorrect 1. 0
Yyy

Thank you so much

**alansidman** · 11-25-2020, 06:28 PM

It would be really helpful if on your spreadsheet you mocked up a solution as your explanation does not quite sync up with what you are showing in the thread.

**Julyexcel124** · 11-30-2020, 06:15 PM

Hi Alan,

I have reattached the sheet with summary i would like to create

Thanks

**Julyexcel124** · 11-30-2020, 06:18 PM

I have reattached the sheet.

Thanks for you help,

**fpkid1** · 12-01-2020, 12:00 AM

How does this look?

**Julyexcel124** · 12-02-2020, 05:56 PM

Originally Posted by fpkid1

How does this look?

Yes looks good 👍🏻
But how did you made the summary ?
By using pivot s?
I have around 10,000 records
Many thanks for helping me
Thanks

**fpkid1** · 12-02-2020, 06:01 PM

If your data source looks like the original, I made those additional columns that turned corrects into 1, and incorrect into 0. You can apply this to all your records then create a pivot table from it

**Julyexcel124** · 12-03-2020, 04:29 PM

Originally Posted by fpkid1

If your data source looks like the original, I made those additional columns that turned corrects into 1, and incorrect into 0. You can apply this to all your records then create a pivot table from it

Thank you so for your reply .
Just a quick thing, as I want all columns total and in pivot we can only show one column total.Isn’t it ?
I mean day 1 , day 2 etc total .In pivots , I will drop day 1 in columns abd group into rows.Where shall I drop day 2,day3 etc

Many thanks

**JeteMc** · 12-07-2020, 01:43 PM

Here is another possibility. Since you are using the 2010 version of Excel, you could download the Power Query add-in (free from Microsoft) and use it to rearrange the data into a row over row format. You could then produce a pivot table from the rearranged data.
The Power Query Advanced Editor code is:

Please Login or Register  to view this content.

In the pivot table you can choose which day(s) you want to display.
Let us know if you have any questions.

Help on creating a summary

LinkBack

Thread Tools

Rate This Thread

Display

Help on creating a summary

Re: Help on creating a summary

Re: Help on creating a summary

Re: Help on creating a summary

Re: Help on creating a summary

Re: Help on creating a summary

Re: Help on creating a summary

Thread Information

Users Browsing this Thread

Similar Threads

Creating Summary Tab

Creating a tiered summary

Creating a new tab from Summary tab

Creating Summary

Creating summary data

Creating a Summary Tab

Creating a summary sheet

Bookmarks

Bookmarks

Posting Permissions