Regression Formula - not working correctly with filters

[jerryr125]

Hi everyone - 

I created the following regression formula:

='y = '&num(LinEst_M(QuantitySold,[Ind-L-H-Estab]),'#,##0.00000')&'(x) + '&num(LinEst_B(QuantitySold,[Ind-L-H-Estab]),'#,##0.00000')

What does not seem to be working is the filters - that is, I have a filter on my sheet for the dimension "State".  When I apply the filter the formula does not work.  

So my question is how can I get the formula to work as the data is 'filtered' using the filter visualizations ?

Any thoughts ? Happy 2022! Jerry

[MarcoWedel]

please post some sample data and your expected result

thanks

[jerryr125 · Accepted solution]

Solved - there was an issue with the data structure - all set - thank you - Jerry