Hello team,
Can Excel pivot be used to get the sum of unique values?
Please let me know.
BittenApple
Sum of the unique values
-
- Administrator
- Posts: 12615
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Sum of the unique values
If you have Excel 365 then you can do this with a simple formula
You do not have the required permissions to view the files attached to this post.
StuartR
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Sum of the unique values
Hello StuartR,
Thanks for the response.
Thanks for formula. Is there any way we can do it in pivot table? I mean to get the sum of unique values?
Regards,
BittenApple
Thanks for the response.
Thanks for formula. Is there any way we can do it in pivot table? I mean to get the sum of unique values?
Regards,
BittenApple
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Sum of the unique values
Not as far as I know. If you add the data source to the Data Model, you can count distinct values, but summing distinct values goes against the grain of pivot tables.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Sum of the unique values
Hans and StuartR;
Thanks for your inputs.
Bitten
Thanks for your inputs.
Bitten