Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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%')),
)