Pivot colum total percentage without directly specify column field name

[valerio_trotta]

Hi everybody,

i don't know if it's possible but i'm calculating a measure in a pivot as the percentage of column total with this expression

count(fieldName)/count(TOTAL <columnFieldName> fieldName)

Is it possible to not specify the column filed name and let a function or something else determine it?

Thanks

VT

[dplr-rn]

You could try with variable like below
um(LineSalesAmount)/Sum(total<$(vDimDynamic2)>LineSalesAmount)

[valerio_trotta]

Hi dilipranjith,

thanks for answering me. I was thinking of using a variable to but what should i put in the variable?

Thanks

VT

[dplr-rn]

the column name you want to use as total e.g.

if your column is Year. Define the variable as Year

[valerio_trotta]

That's kind of what i was hoping to avoid, to specify the name of the field.

So far i'm using a variable defined as  GetObjectField(2) which works fine in this case because i have two dimensions on the rows and only one on the cols in this pivot, if i use it in a different format of pivot table it won't work correctly. 

In the end i'd like to avoid writing the dimension name at any level, if it's possible.

Thanks

VT

[dplr-rn]

i am not sure what your exact requrirements are. Only thing i can do is point your in rought direction which is to use the variable and make it dynamic on someway