Forum Discussion

Jessjess1150's avatar
Jessjess1150
Copper Contributor
Sep 29, 2021
Solved

Data Sheet - Pivot Table -One Result Return

Good afternoon!

 

I have a data file where I would like to be able to return one result when there are multiple duplicate entries for that same results so when combined, it does not add up the total but instead show that ONE result. 

 

For example, I may have one estimate budget that contains multiple entries with the same repeated number. When view within a pivot table, it adds up the total to give me an inflated number instead to give me simply the estimate number.

 

 

  • Juliano-Petrukio's avatar
    Juliano-Petrukio
    Sep 29, 2021
    If it solves your problem, please flag it as solved.
    Remember that hitting the like button is less costly than buying me a coffee. 😉

5 Replies

Resources