topic Include a dimention in App Development

Include a dimention

niranjana — Mon, 22 Jan 2024 10:42:53 GMT

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?

Re: Include a dimention

Anil_Babu_Samineni — Mon, 22 Jan 2024 14:11:34 GMT

@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))

Re: Include a dimention

niranjana — Mon, 22 Jan 2024 15:07:16 GMT

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