Sum issue
Hi Folks, Trying to do something with 6 stock periods, though the table below only shows 3. I have employees that have 6 columns of shares with different vest dates. What I want to do is Sum acro...
Forum Discussion
parry2k The total # of shares of each employee based on the date range.
Basically, all I want to see the total shares each individual has on a date range of Nov 1 2017 up to December 31, 2022. Problem is that they get a batch of shares at each vest date. Plus some of the data has shares already vested which I don't want which is why I need the date range.
Many thanks!!!!!!
it required unpivot of data and then it is easy, i quickly put together pbix for your reference, change it as per your need.
https://drive.google.com/open?id=0B4dPgH9_BPBrOG9rR01HOGFjOGM
