Forum Discussion

AliceW's avatar
AliceW
Power Participant
7 years ago

Filters / using them for a new column

Hello good people! After many attempts, I gave up home of solving this myself so here I am. Your time on this will be appreciated.   So, I have a table showing the Opportunities present in a given...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

AliceW ,

 

Based on your sample data and description, you want to move the Final Date Subscription to the INITIAL Date rows based on user selection, right? So why the fourth line in table visual can't be moved?

 

 

Regards,

Jimmy Tao

  • AliceW's avatar
    AliceW
    Power Participant
    7 years ago

    Hi v-yuta-msft Jimmy,

    I can't figure out how to copy the Subscription ACV value in the 'final' line of the same Opp number in a new column in the 'initial' line.

    I'd like to have both 'initial' and 'final' Subscription ACV value of, say, Opp #1 in the 'initial line.

    I was thinking to maybe creating a new table (somehow) with only the 'final' versions and connect it to the existing one. Then, I could go crazy with the RELATED function and bring everything in, as it would be a many-to-one relationship.

    Thanks!

    Alice