Pivot Rows and calculations

@woliveiras We would love to see what you have made here once you have it. Thanks for letting us know that you would like to accept the soluton. I marked Emily’s reply as solution by clicking the checkbox under her reply. Thanks!

@emilyzhu ,
Is there is any update on all value to IN() function, or there is in any alternate to overcome this