6 Replies Latest reply: Feb 11, 2013 1:11 AM by Phaneendra Kunche RSS

    Lebel for Totals in Pivot table

    Dinesh Kumar

      Hi All, Hope you are doing great.

      I have this minor issue which I am not getting right. In my below chart (see image), I have values for whole 2011 but only till Sep in
      2012. So while doing sum, I want to display YTD Total during the current month else just the Total (as in 2011). I tried many functions/conditions but maybe
      it is not my day today .  Any suggestions? Thanks for your help in advance.

      Total Issue.jpg