Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following table
Make | Model | Price | Sales | Total | |
ABC | 1 | 500 | 2 | 15 | |
ABC | 2 | 2000 | 3 | 15 | |
ABC | 3 | 3000 | 4 | 15 | |
ABC | 4 | 2500 | 6 | 15 | |
DEF | 1 | 1000 | 6 | 2 | |
DEF | 2 | 300 | 3 | 2 | |
DEF | 3 | 5000 | 5 | 2 | |
DEF | 4 | 350 | 8 | 2 |
I'm trying to calculate the "Total" Column which is the total sales of each Make, what do i need in my measure?
Thanks
Kev
@kev6brown try below
=sum(total <Make> Sales)