BLACK FRIDAY SALE 20% OFF ALL COURSES
Log In
Register
Home
Stock Dashboard not sorting or filtering correctly
Brad Kearns
New Member
Members
Forum Posts: 1
Member Since:
June 7, 2021
June 7, 2021
Offline1
June 7, 2021 - 10:39 pm
The following formula is not working correctly in cell B6(it pulls in every reference of the stocks in the Ledger table):
=SORT(UNIQUE(FILTER(Ledger[Stock],SUMIF(Ledger[Stock],Ledger[Stock],Ledger[Units])<>0)))
Sheet is attached.
Please advise
Mynda Treacy
Admin
Forum Posts: 4647
Member Since:
July 16, 2010
July 16, 2010
Offline2
June 8, 2021 - 9:53 am
Hi Brad,
Welcome to our forum!
When I opened the file I could see momentarily the duplicate stocks, but as soon as the formula recalculated, I only see a unique list. I wonder if your Calculation is set to manual? Check on the Formulas tab > Calculation Options.
Mynda
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Raymond Bowring, Tony Brett
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1864
SunnyKow: 1432
Anders Sehlstedt: 886
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 241
Hans Hallebeek: 222
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Agnes Welch
ANTONIO FERNANDEZ FLORO
Arisa Atajewa
Tony Brett
Martha Hennen
Gweneth Henderson
EDWARD JAMES
Ashley Williams
Brian Sutera
Marc Frappier
Forum Stats:
Groups: 3
Forums: 24
Topics: 6638
Posts: 29118
Member Stats:
Guest Posters: 49
Members: 33064
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —