Hi
I have on set of data with vairous forumules calculating different pass and fail rates etc, and I wish to create a pivot table without using the pivot table funstion to show all totals in one table.
See attachment.
Hi
I have on set of data with vairous forumules calculating different pass and fail rates etc, and I wish to create a pivot table without using the pivot table funstion to show all totals in one table.
See attachment.
Are you saying that the pivot table works but you want an alternative approach?
I would STRONGLY recommend that you use the pivot table as the basis so you know you have all the dimensions (Sites and Test/Pass/IP/Overdue/Fail categories)
Aside from that if you know the dimensions will not change EVER, then this formula will work in cell N8:copy and paste that in N8 then drag to Q22.Please Login or Register to view this content.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks