below i've shown the data I have and need what is present in the column Need. Its a pivot table but i'm not able to use it according to how i want. I need to sum it group wise. Groups are based on different colors and i want to divide each year by the group sum year number.
I've tried creating a calculated Field in pivot but that is also not showing it on parent level.
Thanks.
best regards,
