1 Reply Latest reply: Feb 13, 2013 10:21 AM by Zhenya Virina RSS

    Mapping between PieChart and Straight Table values

      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!!!!