John Koger Posted December 7, 2022 Share Posted December 7, 2022 exampleExample I want my new column to show 2 existing column show UBER *TRIP 5 existing column show Amazon Prime Link to comment Share on other sites More sharing options...
Gaia Paolini Posted December 7, 2022 Share Posted December 7, 2022 To count the number of occurrences of your first column (call it [col1]) then add column [group_id] asDenseRank(RowId(),[col1])This can be used to filter (set filter to group_id=1). To calculate the number of rows for each value of [col1] you can use the expression:Max([GroupID]) over ([col1]) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now