Results 1 to 1 of 1

Thread: Can I get a Result Evaluating a Row Field.

  1. #1

    Lightbulb Can I get a Result Evaluating a Row Field.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 1St MFG 1
    Right 1St PKG 1
    4567 2
    Not Right 1St MFG 1
    Not Right 1St PKG 1
    3456 2
    Not Right 1St MFG 1
    Right 1St PKG 1
    5678 2
    Not Right 1St PKG 1
    Right 1St 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.Analysis.xlsx
    Last edited by Lector; 2015-04-11 at 08:41 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •