Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try 'Suppress Zero Values':
this is already checked on all my expressions/dimensions