Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi dilipranjith,
thanks for answering me. I was thinking of using a variable to but what should i put in the variable?
Thanks
VT
the column name you want to use as total e.g.
if your column is Year. Define the variable as Year
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
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