4 Replies Latest reply: Apr 1, 2016 2:40 AM by raadwiptec g RSS

    calculated!

    raadwiptec g

      Hi All,

       

      In Nprinting I have a pivot excel template which has few columns like below

       

      Amount  ¦ Input ¦ Month  -- these are source . Once the input gets as a source for ex

       

      Input

      +Vendors  +Customer -if you expand vendors or customers we can see each month

       

      now i need to add vendors + Customers as calculated field..

       

      the problem is vendors and Customers are output from input column of the source

       

      any sugge..

        • Re: calculated!
          raadwiptec g

          any suggestions here

          • Re: calculated!
            James Summerson

            You can pass parameters and filters in NPrinting based on what's in your QVW, but I can't see what you're trying to do.

            • Re: calculated!
              raadwiptec g

              hi james

               

              Based on a QVW chart.i have prepared a pivot table in nprinting report. in the pivot table their are 3 columns

               

              input column - values are vendors and customers- so when we run the nprinting report the report looks as below- this is collapsed version

               

              sum Amount     ¦ input                         ¦ Month

                                    +Vendors  + Customers  

               

              expanded version

              sum Amount     ¦ input                         ¦ Month

                                    +Vendors                      + Customers  

                                     01 ¦ 02 ¦ 03 ...12            01 ¦ 02 ¦ 03 ...12

                                      0.5¦ 100¦ 150                  200¦ 240¦ 234 ....

               

              now i need to add an  additional calculated column  in pivot table    'difference' which is vendors - customers in the pivot chart of nprinting. We can make the difference directly in qvw but iam checking whether their is an option in nprinting itself.

               

               

              sum Amount     ¦ input                         ¦ Month                  ¦ difference

                                    +Vendors                      + Customers         

                                     01 ¦ 02 ¦ 03 ...12            01 ¦ 02 ¦ 03 ...12

                                      0.5¦ 100¦ 150                  200¦ 240¦ 234 ....