Forum Discussion
Dynamic Calculated column in matrix
Hi ,
How to create dynamic calulated(Total) Column in matrix by using the names.
For example i have two names like ABC , DEF and in future the new name will add say GHI with values.
Now i need to calculate a column with the values dynamically.
why am asking to calculate the column is i need to move the total column from right to left.
Sorry for my poor Explanation .
And thank in Advance.
Regards,
Suresh Pantra.
10 Replies
Hi Anonymous
I think the best option would be to unpivot the data so that all your labels (ABC, DEF, GHI etc) become values in a single column with the corresponding numerical values in another column.
To do this, in the query editor select any columns that you want to be fixed (in your example the 'Attributes' Column) - note that there is no need for a total column - and select 'Unpivot Other Columns'. You can rename this column e.g. to 'ColAttributes'
In the report view, create a measure which just sums your numerical values column and then in the matrix have your Attributes columns on rows, your ColAttributes column on columns and ensure you have the option for column sub-totals selected
Hi rsaprano,
Thank you for your reply.
It is an unpivoted data. Can you please explain in detail.
Regards,
Suresh pantra.
Hello Anonymous
Can you please share a sample of your data so we can copy an paste (not a picture)? That will help us answer the question.
