2 Replies Latest reply: Sep 11, 2013 5:54 AM by Vishwaranjan Kumar RSS

    Pivot chart - columns with Totals

    Erik van hout

      I can't seem to get totals into my pivot chart.

      I'm looking for this result:

      BUClusterSiteProcessActivityUOMTot Act. Hr08-09 Act. Hr09-09 Act. Hr10-09 Act. HR
      InboundUnloadPallets147604047
      OutboundPickBoxes33011012298
      OutboundLoadPallets130505030
      OperationsSupervisionHour3616812

       

      In my example I've added 3 days, but it should be possible to show every day of the year.

      For the column Tot Act. Hr I'm trying to add a calculated dimension - but I'm not getting the calculation right.

      Can anyone help me out?