This content has been marked as final. Show 2 replies
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)".