For each opp we have multiple events and I want to identify the first one so I can use the information in one of the fields as part of another calculation. For example if the key info field is "F" then set a second calculation to 1, so I can see how many "F"s there are in the set.
I do NOT want to have each event (row) show in the view.
So bringing in the required dimensions and creating a standard calculation and then hiding headers after won't fix my issue, since that requires showing each row. This is an over simplified example, but in the real life workbook , the oppID is one level part of a group of dimensions (Geo, Team, Rep, Opp type, Opp).
Essentially i would like to replicate a partition OppID order by date, but without having the date show in the output. See screenshot for the sample data in the first three columns, the expected outcome for each row, sample tableau calculation to use that partition # data to ID key opportunities.
attached the data in the partition help file
