2 Replies Latest reply: Oct 2, 2012 12:02 PM by Dwight Kellett RSS

    Ignoring a dimension based on user selection



      I have a chart which I want the users selected date(s) to be ignored as I want to present all the dollar values totalled by year. I've attached a sample file.


      My problem is that when calculating "Equity" the dollar value is correct for the user selected year but out for all the other years, even though my expression is coded to ignore the date selections. I can't figure out why the dollar value is only correct for the selected year?