Urgent Help needed in expression

[#1]

Hi

I am facing some calculation issues in Pivot table .

i need the chart to be as in the pic

i am sharing the excel sheet and QVW for the reference.

So, kindly help me out to resolve the issues for the expression

[Anonymous]

Hi,

Are you looking "P-Rate QTD" as a part of your expression? You may try below,

=IF(Match(ServiceOLR.TYPE,'Budget', 'Actuals', 'P-Rate QTD'), NUM(SUM(ServiceOLR.AMOUNT), '#,##0'),

  IF(Match(ServiceOLR.TYPE,'Actuals %'),

  Num(SUM({1< ServiceOLR.TYPE = {'Actuals'}>} total <ServiceOLR.SUB_REGION, ServiceOLR.COUNTRY, ServiceOLR.PL> ServiceOLR.AMOUNT) /

  SUM({1< ServiceOLR.TYPE = {'Budget'} >} total <ServiceOLR.SUB_REGION, ServiceOLR.COUNTRY, ServiceOLR.PL> ServiceOLR.AMOUNT), '#,##0%')))

[#3]

Yes

i got it but my query lies in if i select in filters the values in "Actuals %" are not changing , but actually values are to be changed as per the source Excel sheet.

Do help me in that way

[Anonymous]

Hi,

I could see the data changes in Actual % after doing filtration and even it is matching with excel. I just uploaded excel you attached. See updated qvw attachment.

[#5]

Satyadev

Thanks for your response

unfortunately i cannot see changes as per the filterations on the Accounts% column

anyways i got the solution .

Thanx for your support