pivot table bar chart values not matching

[#1]

hi all,

i have one issue pivot table expression and bar chart expression both are same  but values are mis matching  if we select in below 2016

please help me

thank in advance

[sunny_talwar]

You might need to do use Sum(Aggr(Expression, Dimensions)) in your pivot table to fix the sub-totals for the pivot table

[#3]

hi stalwar1

in pivot table values are coming correct but bar chart values are going wrong

[Anil_Babu_Samineni]

Check this, I didn't any wrong value here. And, i assume for pivot you may need like below

Expression for Pivot

=Aggr(if(Sum(Aggr(SUm(RADat_DUE),RADat_Project,RADat_SubProject,RADat_LESSEE_ID,RADat_BILL_ID))

- sum(if(RR_Receipt_date<=Date(T_Date,'DD/MM/YYYY'), RR_RECEIPT_AMT))

<>0, Sum(Aggr(SUm(RADat_DUE),RADat_Project,RADat_SubProject,RADat_LESSEE_ID,RADat_BILL_ID))

- sum(if(RR_Receipt_date<=Date(T_Date,'DD/MM/YYYY'),RR_RECEIPT_AMT)),0)/Value, Dim1, Dim2,....)

[adamdavi3s]

This is because your pivot table is being limited by the dimension:

=if(RADat_INVOICE_DATE<=Date(T_Date,'DD/MM/YYYY'),Lesse)

Where as your bar chart is not.

If you simply change the dimension in your pivot table to be "Lesse" then this works:

I can't see any need to limit the values for 'Lesse' with the IF statement as the relevant values will be ex/included based on your expression and other calculated dimensions anyway

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

This will help users identify the answers should they come across this thread in the future.

[#6]

HI ANIL,

CAN  YOU UPLOAD THE QVW

[#7]

Hi  davies,

in pivot table values are coming correct,i am eliminate the null values of lesse

in bar chart  iam not able to eliminate the null values of lesse

if we uncheck the null values of lesse then pivot and bar chat are matching