0 Replies Latest reply: Oct 10, 2011 3:35 AM by pradeep kushwaha RSS

    copy full table is not working properly

    pradeep kushwaha

      Hi please help me to resolve the below issue.

       

      input file :

      Type Of Circuit Month Avg % Uptym
      Aug 2011 99.713
      VPN-NATIONAL Sep 2011 99.95
      Jul 2011 99.987
      Aug 2011 99.997
      Jul 2011 100
      MANAGEDSERVICES Aug 2011 100
      INSTACC Hosted Sep 2011 100
      NPLC Sep 2011 100

       

      after formula pivot result is as below:

       

      dimention (Type od circuit,month)

      Expression sum(Avg % Uptime)

       

      Type Of Circuit Month Jul 2011 Aug 2011 Sep 2011
      INSTACC Hosted - - 100
      MANAGEDSERVICES - 100 -
      NPLC - - 100
      VPN-NATIONAL - - 99.95
      - 299.987 199.71 -

       

      again i want to replace null value with 100 which i did using presentation tab.

       

      Type Of Circuit Month Jul 2011 Aug 2011 Sep 2011
      INSTACC Hosted 100.00 100.00 100
      MANAGEDSERVICES 100.00 100 100.00
      NPLC 100.00 100.00 100
      VPN-NATIONAL 100.00 100.00 99.95
      100.00 299.987 199.71 100.00

       

      now i want the last result in bar chart. but i am unable to set blank as 100 in bar chart.

      Please help. attaching sample qvw for reference