3 Replies Latest reply on Oct 3, 2016 2:27 AM by praveen p

    Bringing Grand Total as a New Column

    Sanket Deshpande

      grand total.png

       

      Hi all,

      I have a scenario wherein i have developed the above bar chart

      • I have my regions and years in columns shelf
      • Segment and My measure in row shelf
      • Im restricting the no.of years shown using last() function and a parameter.
      • What i want is an additional column as Grand total at end  which gives me Total of each segment for each year.
      • for eg for seg 'a' it should display 4 bars for 4 years as total at end

       

      Please help me with the same

       

      Regards,

      Sanket