This content has been marked as final.
Show 2 replies
-
Re: How to make dynamic percentage calculation for each group on pivot
Petter Skjolden Mar 30, 2018 5:52 AM (in response to kaan erisen)Furthermore you can make it dynamic as to which two first dimensions you put in the pivot by using the GetObjectField() function. It is a rather strange name for the function since it retrieves the name of the dimension you select:
Sum(VALUE)/SUM(TOTAL <$(=GetObjectField(0)),$(=GetObjectField(1))> VALUE)
This expression will adjust to whichever dimensions you put in the pivot.