1 Reply Latest reply: Apr 9, 2012 5:39 PM by Joshua Goldner RSS

    Count and Rank table chart by 2 expressions: current and YTD

    Joe Kirwan

      I have a straight Table chart with expressions for Current Month Sales (as selected) and YTD Sales (using SET Analysis).

       

      Dimension is Customer.

       

      I want to introduce columns based on Rank and Count.

       

      Some YTD Customers will have no activity in Cuurent Month.

       

      How can I exclude these from the Rank and Count calculations for Current Month?