Record click gives new table

I did ask the question before, but now I know what the problem is, but not how to fix it.

This was the question

1h,1d,ect does not give info, it only show [record], I am using this for excel 2016

Now I did go and click on the record in the column, but now it gives me this info.


How do I get it to show the 1h change in %, is there a formula to do this

Percent change in our API is as a fraction. To get a normal percentage you would multiply by 100. So 0.07 becomes 7%.

Thank you for your info, it did help me.