I have a Straight Table with Type, Channel, Target, Actual. The Actuals accumulate over time but the Target is set once a year. In the table, I take the min(target), and then sum(actuals). But when I total, I can't get the targets to add up, they too are giving me the min.
=num(min(Target),'#,##0.0',)
I am doing Sum of Rows on the Expressions tab.
Type | Channel | Target | Actual |
Branch | Arkansas | 18 | 13 |
Branch | Central Florida | 34 | 16 |
Branch | Georgia | 36 | 20 |
Branch | Gr Wash | 36 | 32 |
Branch | Greater Atlanta | 37 | 24 |
Branch | In-Store | 38 | 16 |
Branch | North & South Carolina | 42 | 22 |
Branch | Other | 46 | 35 |
Branch | SFlorida | 48 | 42 |
Branch | Southeast | 59 | 24 |
Branch | Total | 18 | 246 |