2 Replies Latest reply: Oct 1, 2012 3:32 PM by Rebecca Molstad RSS

    visible values for a distinct total <> expression

      I am trying to create a table that shows a total of monthly calls in one column and the YTD totals in the next, but without showing the rest of the months in the year

       

      my dimensions are MonthYear and IDName

       

      in order to capture the monthly calls, I have the following in the set expression: CallDate={">=$(vMonthReportMin)<=$(vMonthReportMax)"}

      in order to capture the YTD calls, I have the following in the set expression: Year={$(=Year(AsOfDate))

      the only differences other than these are that for the YTD expression i have it counting distinct total <Year, IDName>

       

      the result is that I have the correct values for each column in the month that I want to select, but the rest of the months are also displayed for the calendar year, which replicate the YTD totals but have zeros for the monthly totals.

       

      i just want that one month without the rest. any advice is greatly appreciated, thanks!