Notifications
Clear all
Dashboards & Charts
3
Posts
2
Users
0
Reactions
400
Views
Topic starter
Dear Mynda
Re. your dashboard from a few years ago. The formula at around 4.40mins. re. Current Holdings Statement on the dashboard. When I type =SORT(UNIQUE(FILTER(Ledger[Stock]. at this point, the data symbols box appears (ie. 52 week High, Low etc) rather than the excel formulae options and therefore I cannot access SUMIF. to complete the formula. I'm a novice so thanks for your guidance on this issue. Steven
Posted : 25/01/2026 10:37 am
Not Mynda here 🙂
As soon as you have entered the column name [Stock], the data options appear. Now enter a comma and the formula options will be displayed again. Did you perhaps enter a period? Then nothing happens.
Posted : 25/01/2026 4:34 pm
Topic starter
Many thanks Riny, and yes, I was entering a period rather than a comma. All good now.
Posted : 26/01/2026 2:32 pm