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

    Percentage per dimension in pivot table

    Maarten Van Damme

      Hello!

       

      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: ?

       

      JobsPercentage.png

      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!

       

      Maarten