5 Replies Latest reply: Oct 5, 2014 12:00 PM by Ashfaq Mohammed RSS

    Excluding selected range

      Hi to Everyone.

      I have a chart with these fields:

       

      Dimenssions:

      -date

      -invoice number

       

      Expression:

      QUANT  (the expression is : sum({$<YEAR-={$(YEAR)}>} PPC_IVQUANT)

       

      I have two field for selection YEARS and MONTHS.

      What I want to do, is to exclude from this tabe  lines where the date falls on the selected dates  range ( The test here is for the year only, but it didnt work out).

      I couldnt it solve it after many times. Please consider that the user can selected some months together.

      I can't use "1-$ " becuse I want the results to  regard the  selected product in a nother field/

       

      I will appriciate any help/

       

      Thnak you,

      Osher Sassoni.