Filtering duplicates and sum the amount

Help Activities
, ,
1

Hello All,
I have an excel file in which one of the column has duplicates with 3W, 4W and 2W. So here I have to add the amount by filtering each 3W, 4W and 2W. Please help me with this.

2

can you provide the input and expected out then we can provide the solution
@ISBS_ROBOT

3

Insurance_Data.xlsx (11.8 KB)

If column “Vehicle Type” same then need to add column “NetPremium”

4

for example if you have 4W in "Vehicle Type’ is duplicate so you need to do sum all the 4W ?

or can you share the expected output

@ISBS_ROBOT

5

For each 4W the amount should get add from Net premium column and print sum amount

6

HI @ISBS_ROBOT

Hope this xaml help for you

xaml :- Filtering duplicates and sum the amount.zip (2.1 KB)

For reference you can see the output of sum of all

1.4W total
image

  1. 3W Total
    image
7

Let me know its working or not for you…

Cheers…!

@ISBS_ROBOT

8

Thank you so much bro, It’s working

Cheers,

1 Like
9

Cheers…! :slight_smile:

@ISBS_ROBOT

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.