Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Expression seems okay, Can you show the Total as well?
Try one of this from chart properties of the pivot chart.
Sum of rows
Expression total
And check which matches your result.
Thank thank Anil for your reply for total I m using
Sum(aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB))
I believe same as before, Seems correct to me. What values are you facing wrong?
thank you Anand for your reply . It didn't work though.
if you see the attached image the sum should result 4 however I am h.getting 6
I can understand your issue, Can you attach application to investigate where values are getting ??
due to security issues unable to upload app.