2 Replies Latest reply: Mar 14, 2016 12:02 AM by Jim Chan RSS

    How to create a Pivot Table?

    Jim Chan

      Hi guys,

       

      Currently i have 2 tables, and i wanted to use Pivot instead of separated into 2 tables.

       

      I want the Pivot to be categorized to "Work In Progress" and Completed With Issued" then, from there, expand to the rest of it.

       

      Now, how i do is -

       

      for "Working in Progress" Pivot table, i just add the edited dimension "=if([Project Indicator]<>'Green',Project_Name)" .

       

      for "Completed with Issued" Pivot table, i just add the edited dimension "=if([Project Indicator]='Green',Project_Name)".

      table.jpg

       

      Rgds,

       

      Jim