Adding up column value

[Rocky6]

Hi Everyone ,

I have a requirement were I need to calculate the dimensions value. 

Eg. I have deposit as dimensions and there value is 

1 month

2 month

3 month

4 month 

Current month

I need to add up 1 month to 4 month as one value and add that value with current month value.

Is there any solution for this.

[Kushal_Chawda]

@Rocky6  is the 'current month' also field value like 1 month, 2 month?

[Rocky6]

@Kushal_Chawda  yes it's field value

[Kushal_Chawda]

@Rocky6  to be honest still not clear what you are trying to achieve but let me give it try

grand total you will get it with below expression

=sum(aggr(sum(Value),Month, Broker) ) //here month is the field that contains 1 month, 2 month etc...

For difference , create table with dimension Broker & Date, with Difference  measure as below

sum(total <Broker>aggr(sum(Value),Month,Broker) )-sum(aggr(sum(Value),Month,Broker) )