If I use straight table or pivot it show diff total in both.In straight table ,it consider the value of Int & Dom & generate correct result.But in pivot table it won't consider the Int& Dom& display total excluding value of Int & Dom
But I need the report ,as display in the pivot table.What to do?
A pivot table will always give you the expression total, where as in a straight table you are able to specify what total you would like, in your example it looks like your straight table has been set to 'Sum of Rows' and not 'expression total'
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