Row level total - pivot

[anagharao]

Hi ,

I have a pivot table that looks something like this

               compliant           in office          no time booked          TOTAL

BU

------------------------------------------------------------------------------------------------------

BU1          16                         5                    3                         24

BU2                                       4                    9                         13

BU3          10                         2                                               12

The BU dimension is straight forward. However the second column in the pivot is an aggregation:

Aggr(FirstSortedValue(COMPLIANCE_DESC , -PRIORITY), EMP_ID)

Now, I want the % of compliance , not just the headcount. I tried adding Count(Total EMP_ID) to the expression, however the results were 49 (24+13+12) in every cell.

How will i get the total value per row? 24 in the first, 13 in the second...

Thanks

Anagha

[Anil_Babu_Samineni]

If you use Partial Sum option checked this will automatic do and display

[sunny_talwar · Accepted solution]

May be this

Count(TOTAL <BU> EMP_ID)

[anagharao]

Thank you !

[anagharao]

Also, what if it is a drilldown group and not just BU?

[sunny_talwar]

May be like this

Count(TOTAL <$(='[' & GetCurrentField([GroupName]) & ']')> EMP_ID)