Forum Discussion
Countif in New Table
Hi jack_oplav,
To achieve your requirement, click column [Step1], [Step2] and [Step3], then click unpivot columns like below:
Then, click column [value] and click pivot columns based on column [Project], the result is like below:
Regards,
Jimmy Tao
Hi jack_oplav,
To achieve your requirement, click column [Step1], [Step2] and [Step3], then click unpivot columns like below:
Then, click column [value] and click pivot columns based on column [Project], the result is like below:
Regards,
Jimmy Tao
Thank you so much! This is just what I was looking for.
I created the new table (Table 2) by duplicating the original table (Table 1) and doing the pivot steps you suggested. When I create the chart based on the Table 2, it does not filter in the report for Table 1 filters. I know the two tables need to be related, but I thought that duplicating Table 1 would automatically update the values for Table 2.
Thanks in advance for your assistance!