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