6 Replies Latest reply on Jun 19, 2017 10:03 PM by Akhilesh Singh

    Exclude

    rocky hill

      Hi Team,

       

      i have a situation where i do have years dimensions under that i do have 5 members and i want to do grand total on that members excluding one member in the grand total calculation.

       

      Ex : Years -2001,2002,2003,2004,2005

                         20      15      16    17     18

       

      Grand Total : 15+16+17+18

       

      But i want to display all that in years in the chart including 2001 (But in the grand total calculation i want to exclude the year 2001 value 20)

       

       

      Thanks in Advance