some quick help from you

[#1]

pivot table calculation issues                    

I created a pivot but I couldnot able to get the exact result

can you guide me to get the exact one

I am using the following expression

IF(Match(ServiceOLR.Type,'Budget','Actuals'), NUM(SUM(ServiceOLR.Amount), '#,##0'),

IF(Match(ServiceOLR.Sub_Region, 'SOUTH PACIFIC'), NUM(SUM({$<ServiceOLR.Sub_Region={'SOUTH PACIFIC'}, ServiceOLR.Type={'Budget'}, ServiceOLR.PL={'MG','9R'}>}ServiceOLR.Amount/100), '#,##0%'), NUM(SUM(ServiceOLR.Amount)/100, '#,##0%')),

   

)

[Anonymous]

In pivot its doing sum of rows. Try using Straight table and see what you are getting.

Partial sums always works wierd in Pivot

[Anonymous]

Basically you are looking for "Expression Total" which you will get in Straight but in Pivot you are getting "Sum of Rows" weird though