Well basically, if you do a sum of rows, any duplicate data will be calculated accordingly. However in the pivot for the total values will only calculate once.
From looking at the table I would say you have the below value against two Terminal_Type, which is counting twice in your straight table but correctly only once in your pivot.
So take a look at your underlying data model to resolve
hope that helps
It is not that Pivot Table is not considering Int& Dom.
The problem is that in your table there are 2 similar values of 2.10
I suggest you use Recno() in the table from where you are picking AOP YTD values and do this is Backend.
This will resolve your problem.
Recno() AS Recno,
based on what I think he has in the model, I don't think that will work.
I don't believe he has [AOP YTD] and Terminal_Type in the same table, as if he did, there would be two row entries for that 2.1 and the charts would calculate the same duplicated number (as each 2.1 would have a different terminal value).
He has Terminal_Type in a linked dimension table I believe, so the single row entry of 2.1 is linked to two values in his dimension table, so the expression total gives the 2.1, and sum of rows 4.2
when I test that as mentioned in the attachment ,it will display the correct data in both straight and pivot table.
But it not work in my application .Is there any other way to resolve this problem at front end,as my application is quite large
tes.qvw 140.0 K
i don´t know your data but you can try 2 things :
sum(aggr(sum(expression), dim1, dim2, dim3))
if that doesn´t help you can try to create a single expression for the total line with dimensionality()...
if(dimensionality()=1, then ....
just add dimensionality() to your table and you will see which value the total line has