Straight table & pivot

[#1]

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?

[#2]

it wont work with aggr

[#3]

Is it possible the same structure using straight table

[michael_maeuser]

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

[#5]

if(dimensionality()=1, then ...???