Hi -
I need help with mapping data from a Straight Table to a Pie Chart. I am working with 2 data source tables, where not all values are shared across tables.
To accomplish what i am looking for in my straight table, I created an 'IF' statement that replaces blank values. Which works perfectly.
Table IF Statement:
=if(left([issue],3)='ABC',('TESTING'),[Project])
- Issue is a common field
- Project only resigns in table 1
Now, when I applied the same logic to my PieChart, all values are visible besides 'TESTING'.
Any recommendations on how to establish relationship between the two charts?
Thank you!!!!
