getting Variance from dynamic columns
My query currently has the characterstics "finanical view" and the under key figures it has "amount" in the columns section.Hence it returns me the amount under each financial view. The number of entries for "financial view " is dynamic based on user entry.
I want to display the variance for the last two financial views.
Now the query displays the amount for each financial view. My requirement is to get the variance for the amounts in the last two columns.
Kindly suggest a way how this can be achieved.