Forum Discussion
Dynamic Calculated column in matrix
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.
Hi jdbuchanan,
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.
Anonymous
The columns ABC, DEF, GHI are seperate columns in your data table? If so you can write a measure to add them together, you would just have to add in new columns as the appear in the table:
Total = SUM ( YourTable[ABC] ) + SUM ( YourTable[DEF] ) + SUM ( YourTable[GHI] )jdbuchanan71 - this measure wouldn't automatically pick up a new column (e.g JKL) which is the requirement!
