2 Replies Latest reply: Jun 28, 2012 3:00 AM by Maarten Van Damme RSS

    Percentage per dimension in pivot table



      I was wondering if somebody could tell me how to determine the percentage a certain dimension is using per row in the pivot table below?

      Dimension1: [WorkType]

      Dimension2: [Employee]

      Expression1 (#): sum([BookedDays])

      Expression2: ?



      So if person 'CKE' has in total 241.2 days worked... 238.2/241.2 is the percentage this person worked on [WorkType] 'Work', while 3/241.2 is the percentage booked on [WorkType] 'Holidays'.


      I already did all kinds of combinations (based on other topics), but none of them seemed to work...

      Thanks in advance!