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?