Include a dimention

[niranjana]

Hi,

I have a table :

with 3 dimenions D1,D2,D3 and one exp E1.

When I put the sum, I get  value 2215. But If I remove dim D3 from table I get value as 2062.

I want table with Dim D1 and total 2215. I want to consider the dimension D3 without including in the table.

I must have D1,D2 and E1 columns.

Is there any way?

[Anil_Babu_Samineni]

@niranjana If this is Pivot table, I had same experience. To get that, I have used. You are anyway no need to add dimensions that you don't need.

Sum(Aggr(Sum(Expression), D1, D2, D3))

[niranjana]

Thanks for your reply. But i still didn't get the result. 

Its  a straight table. I must have the dimension D1 and expression E1. Also, I must get calculation considering/including D3 in the exp but not in the table dimension.

Thanks

Niranjana