4 Replies Latest reply on Aug 15, 2018 9:40 AM by Gurpreet Singh Goraya

# Aggregated values based on first three numbers

Hello All,

I am seeking help to aggregate values based dimension. If dimension first three values are same, I need to aggregate them. In the provided example I want an aggregated value of  Fruitid  like 102 &102BD, 104 & 104BD. Please advise. I would appreciate the help. Thanks

 Fruitid Quantity 101 2 102 5 102BD 6 103 6 104 7 104BD 8 Expected Result Fruitid Quantity 101 2 102 11 103 6 104 15
• ###### 1. Re: Aggregated values based on first three numbers

Here It Is:

Thanks

Deepak

1 of 1 people found this helpful
• ###### 2. Re: Aggregated values based on first three numbers

Hi Gurpreet,

Create a calculated field like below

Arrange the cells like below you will get the desired output

Hope this helps kindly mark this answer as correct or helpful so that it will help others

BR,

NB

1 of 1 people found this helpful
• ###### 3. Re: Aggregated values based on first three numbers

Great! Thak you Naveen.

• ###### 4. Re: Aggregated values based on first three numbers

Deepak Rai , thank you Deepak for the reply. Much appreciated.