Forum Discussion
YYS89
Aug 08, 2023Copper Contributor
Power Pivot help needed - calculating share per segment
hi all, I'm working in a CPG company and want to set up a power pivot to calculate shares for me. However when I set up the calculation in the Power Pivot itself, you will see that the value sha...
nimesht
Aug 12, 2023Iron Contributor
Hi YYS89
Right Click on the column to modify the value (currently "Sum of Value Share Year Ago") and choose "Show Values As" > "% of Parent Total" and choose Country field in the dialog box.
Use Like if this post helped to solve your issue and Mark as Best Response if the request can be closed.