Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

FIltering specific values across multiple rows

I have a table of customers and different invoices raised, sometimes for the same customer

 

I want a table to show me the latest update for each invoice

 

i used the below calculated column however, it is now pulling the latest status update for all duplicated customers even if each invoice is at a different stage

 

 

is there a way to show the status for each individual invoice for each customer rather than grouping all customers together and showing the latest status update??

Need Help
Show and Tell
Tips and Tricks
  • selimovd's avatar
    selimovd
    5 years ago

    Hello Anonymous ,

     

    can you paste here the table or a few lines with the relevant columns?

    This makes it easier to analyze the issue.

     

    I also don't see the column [Project Title] in the screenshot, so it's hard to analyze the problem. Probably the context transition doesn't work. Did you try to put a CALCULATE around the MAXX statement?

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

4 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hello Anonymous ,

     

    can you paste here the table or a few lines with the relevant columns?

    This makes it easier to analyze the issue.

     

    I also don't see the column [Project Title] in the screenshot, so it's hard to analyze the problem. Probably the context transition doesn't work. Did you try to put a CALCULATE around the MAXX statement?

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi selimovd worked exactly as i had hoped

     

    i had been trying to figure this out in another post i had up, just by chance i came across the part solution and you have helped complete it

     

    am i able to tag this answer into my other post?

     

    thank you again!! 😀