Get value from Pareto table cummulative

[eduarpad]

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?

@Pareto 

 

[v-janeyg-msft]

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.

[Ashish_Mathur]

Hi,

I solved a similar question here.  Hope it helps.