Forum Discussion
Sum issue
The data I have can only be delivered in that format from the system. There are about 50 other fields in addition to the ones notated, but the ones I put down are the only ones I care about. I have a table visual on another page and this is the end goal:
| Empl ID | Job Title | Salary | # Shares | Value (@ $18/share) | Total Comp | Group |
| 100000 | VP | $ 400,000 | 334 | $ 6,012 | $ 406,012 | Engineering |
| 200000 | Manager | $ 150,000 | 458 | $ 8,244 | $ 158,244 | Communications |
Shares being the # of shares from the data notated in previous post with vesting dates greater than Nov 1, 2017.
So you see, I can't do it like that because I need to put it in a table that is not date filtered which is why I need to get this in a measure format...
Not everyone will have stocks and there are times where I may need to kick out Vest 1 and Vest 2, only to include Vest 3 or change the date parameters in a measure...
sorry buddy, i'm not very clear what i proposed why that will not work. i'm surely missing something here. i hope someone else can help.