1 Reply Latest reply: Mar 23, 2017 5:52 AM by Wouter Mak RSS

    PPT chart in nPrinting by aggregating column values

    sandipan bepari

      Hi,

       

      Please help us with the below query in nPrinitng. We are on a very stringent timeline and any help at the earliest will be highly appreciated.

       

      I am trying to create the below shown bar chart in PPT using nPrinting.

       

      Desired Output.png

       

      The data for the given chart is as below

       

      Column1

      Column2

      Value

      F

      B

      32.28349061

      F

      In

      2.354230797

      F

      R

      1.001463105

      I

      Cm

      2.010747889

      I

      Cn

      12.67959864

      U

      El

      1.197299814

       

      Note:

      • The output chart should have all six Column2 (blue bars) along with aggregated values of three Column1(red bars)
      • We want to create the above PPT output without making any modifications in QVW file
      • We tried to write aggregation formula for each value and drag them in the chart backend excel data file, but formulae doesn't work in this case

       

      Thanks in advance!

      Sandy