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.
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
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.
Lot | Right 1St MFG | Right 1St PKG | Right 1St Both |
Lot | Right 1St MFG | Not Right 1St PKG | Not Right Only PKG |
Lot | Not Right 1St MFG | Right 1St PKG | Not Right Only MFG |
Lot | Not Right 1St MFG | Not Right 1St PKG | Not 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: