Total for calculated dimension is showing wrong

[ashis]

‌

Hi ,

I have calculated dimension in one pivot table.

The definition of the calculated dimension is as follow:

aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB)

Now I want to print the total of this with its label.

Now for total I am using following code total:

Sum(aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB))

My problem is the result of the total is not matching with the dimension value. Please see the attached screen shot.

Please advise what wrong I am doing here.

[Anil_Babu_Samineni]

Expression seems okay, Can you show the Total as well?

[its_anandrjs]

Try one of this from chart properties of the pivot chart.

Sum of rows

Expression total

And check which matches your result.

[ashis]

‌Thank thank Anil for your reply for total I m using

Sum(aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB))

[Anil_Babu_Samineni]

I believe same as before, Seems correct to me. What values are you facing wrong?

[ashis]

‌thank you Anand for your reply . It didn't work though.

[ashis]

‌if you see the attached image the sum should result 4 however I am h.getting 6

[Anil_Babu_Samineni]

I can understand your issue, Can you attach application to investigate where values are getting ??

[ashis]

‌due to security issues unable to upload app.