Forum Discussion

naveenvs's avatar
naveenvs
Frequent Visitor
5 years ago
Solved

Summary Table

This is how my base table data looks like

I needed to add an additonal column "Status" here which worked on a if statement. If (Pass=Total, 'Passed", "failed") and was successful in doing that. Here is howit looked like. 

 

Now I again have to build a summary table based on the status column and the Catefory to show how many subcategories have passed or failed. Please help. Ideally the table would look like below:

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi naveenvs ,

     

     

    Select Count

     

     

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi naveenvs ,

     

     

    Use this as a Visualization in  matrix .

     

     

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

    • naveenvs's avatar
      naveenvs
      Frequent Visitor
      5 years ago

      Thanks for the reply. When I do that I still get the sum, but I am looking for the Count (which is the selection).

      I assume it is because of the way I am caluckating status. This is what I get

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi naveenvs ,

         

         

        Select Count

         

         

         

        Regards,
        Harsh Nathani
        Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)