insert two rows in matrix table

Anonymous · ‎09-27-2021

Hi,

Actually i have matrix table here i need to add two rows at start position but there two rows are not avaible in the table

example

	fc	act	diff
volume	100	50	50
per eq vol	200	100	100
a	200	100	100
b	300	200	100

here a,b rows coming from tables but above two i need to show how can i achieve it.

v-yiruan-msft · ‎09-30-2021

Hi @Anonymous ，

Could you please provide the original data in the table? Also, are columns fc, act, diff, a and b the fact fields in the table? Or are some of them measures? If they are measures, please provide the corresponding formula. Also, please provide the calculating logic of volume and per eq vol, thanks.

Here are some threads that have similar requirement to yours, you can refer to them to implement your requirement.

Row level calculation for making P&L account from Trial Balance

Display original values and their difference in the same table

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.