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 ne...
Provide a sample data that can be copied here and show your expected output.
Thank you
Hi mussaenda,
PFA
| Category | Attribute | ABC | DEF | GHI | Total |
| Motor_vehicals | Accessories | 23 | 32 | 54 | 109 |
| Bikes | 34 | 23 | 32 | 89 | |
| Cars | 54 | 23 | 23 | 100 | |
| Trucks | 45 | 12 | 13 | 70 |
expecting the total column which i need to use next to the attribute Column.In future for example if JKL data has came it has to calculate that data also into the total.
Regards,
Suresh Pantra.