Can I get a Result Evaluating a Row Field.

Lector

New member
Joined
Apr 11, 2015
Messages
1
Reaction score
0
Points
0
Hi,
I am trying to execute an analysis on Excel 2013, based on Spreadsheet which update daily.
I am trying Pivot Tables, but I did not found a way which allow me calculate a result base on the results of the pivot Table.
I am attaching a file which describes what I am doing and what I am trying to do.
Basically, what I am looking is if I can get a Result from a Pivot Table, Evaluating information on the Row Fields in this case (Results).
Examples, If the result of a Pivot table is:
Rows Values
Lot Results
1234 2
Right 1[SUP]St[/SUP] MFG 1
Right 1[SUP]St[/SUP] PKG 1
4567 2
Not Right 1[SUP]St[/SUP] MFG 1
Not Right 1[SUP]St[/SUP] PKG 1
3456 2
Not Right 1[SUP]St[/SUP] MFG 1
Right 1[SUP]St[/SUP] PKG 1
5678 2
Not Right 1[SUP]St[/SUP] PKG 1
Right 1[SUP]St[/SUP] MFG 1
What I want to evaluate is:
This is what I need to get.
LotRight 1St MFGRight 1St PKGRight 1St Both
LotRight 1St MFGNot Right 1St PKGNot Right Only PKG
LotNot Right 1St MFGRight 1St PKGNot Right Only MFG
LotNot Right 1St MFGNot Right 1St PKGNot Right 1St Both

I am thinking is pivot tables, but If could be another way. Macro or another way I really appreciate your Thoughts.
Thank you very much.
Leo.View attachment Analysis.xlsx
 
Last edited:
Back
Top