Aug 04 2021 10:19 AM
https://techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/9832
Thanks for setting it up. I need to calculate a few different columns so I copied the table and tried using a different formula. Why did my table put the same value in all cells while yours (the 10 year sum) worked? I picked the E18 for the row input and E19 for the column input. Note, I also tried to replicate yours on the DS Comparison page and it didn't work either.
Aug 05 2021 02:05 AM
SolutionAug 05 2021 08:15 AM
Got it! I fixed that and it is almost working completely. Yay! However, two lines are calculating the same but no others. Any ideas on how to fix it?
Aug 05 2021 09:59 AM
Aug 05 2021 04:28 PM
Make sure your calculation is set to Automatic and not Automatic Except for Data Tables
Glad to help
Aug 05 2021 02:05 AM
Solution