Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@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))
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