5 Replies Latest reply: Sep 15, 2016 1:27 PM by neelam sehrawat RSS

    Different Filter for each excel column in NPrinting

    Arviddree Sanjaya

      Hi All

       

      Currently i am using Nprinting version 15.3 for creating report on excel file.

      I want to create a report a nprinting report based on my qlikview document,
      What i want to achieve is someting like this

       

       

      FormulaCurrent yearLast YearQuarter 3YTD
      a+b10232155
      a+b+c50808070
      a+d+e60706050
      a+b+c+d+e100150150120

       

      For now i should create a formula one by one per cell example :

      for a+b current year = sum({<Formula={a+b},Year={2016}>}Sales)

      a+b Last year = sum({<Formula={a+b},Year={2015}>}Sales)

      a+b Quarter year = sum({<Formula={a+b},Quarter={"Q3"}Sales)

       

      and for  a+b+c

      for a+b+c current year = sum({<Formula={a+b+c},Year={2016}>}Sales)

      a+b+c Last year = sum({<Formula={a+b}+c,Year={2015}>}Sales)

      a+b+c Quarter year = sum({<Formula={a+b+c},Quarter={"Q3"}Sales)


      My Question is can i apply different filter for each column? Current Year column = 2016, Last Year Column = 2015 etc.....

      currently i am using formula for showing the value.


      Appreciate any help

      Thanks