Forum Discussion

eduarpad's avatar
eduarpad
New Member
5 years ago

Get value from Pareto table cummulative

Hi, need your help. I'm trying to get the value under the "Cummulative Spend by FY" column that matches the 80% on column "Cummulative % by FY", as I don't have the exact 80% but instead 80.2 or something %, need the value to be met the closer to 80%. Thing here is that I need the card to be able to change once I filter the Year.

Can anyone help please?

Anonymous 

 

Need Help

2 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, eduarpad 

     

    According to your description, Do you want to display the value of Cummulative Spend by FY when the absolute value of (0.8-[Cumulative]% by FY) is the smallest? 

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.