2 Replies Latest reply on Sep 18, 2018 11:36 AM by Stephen Hellyar

    How to fill in blanks and still display Area Chart as a Percent of Total using Cell?

    Stephen Hellyar

      I have an area chart.  It track sales.  This is the cross tab. 

       

      Product20132014201520162017
      Widget X165412241674
      Widget Y64676757657546763719
      Widget Z145123136

       

      The are no records for the blank years.   This creates some challenges when using an area chart.  

      I use the following calculation to assign a 0 to all blanks. 

      • ZN(lookup(sum([Sales]),0))

      This works, but it prevents me from using a Quick Table Calculation to display the Area Chart as a Percent of Total calculated using Cell.  In fact, it does not even give the option to use a Quick Table Calculation.

       

      How can I assign 0 to the blanks AND use a Quick Table Calculation to display the area chart as a Percent of Total calculated using Cell???