calculated!

[raadwiptec]

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

[raadwiptec]

any suggestions here

[Anonymous]

Can you reply with some screen shots and a few more details of what you are trying to accomplish?

[ThornOfCrowns]

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.

[raadwiptec]

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