4 Replies Latest reply: Jan 27, 2017 6:03 AM by kushal chawda RSS

    neglecting selections in a particular field without using set analysis?

    DIVYA ANAND

      I have created a bar chart in which [Month-Year] is the Dimension & the expression is as shown below-

       

      =Count(DISTINCT Aggr(If((STATUS<>'CNCL' AND COMPLETED >= MonthStart(Max(Date)) and Match(Type, 'Scheduled','Completed')),
      CODE), Month, CODE, COMPLETED, SCHEDEND, Type))

       

       

      Now when a selection is made in the list box "Month", the data only with respect to that month is shown in this bar chart. How do I make any selections made in month/year/[Month-Year] not effect this chart?

       

      Using set analysis will work, but since I am using Aggr function here, not sure how to fit this in. Does anybody have an idea on this?

       

      Thank you.