Forum Discussion
substract in two table
Hi Anonymous ,
You may consider using the following steps:1. Duplicate the table 'Demand' and 'Supply'
2. For the copied table, select the [Item], [Sub] column and unpivot the other columns.
3. Then merge them as a new table:
4. Expand Supply[Value] as [Value.1] and add custom column like:
5. then remove [value] and [value.1] and select the [Attribute] column to pivot the [Custom] column:
6. select [Aug-22] ~ [May-23] column and replace null to 0.
7. result:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi Anonymous ,
You may consider using the following steps:
1. Duplicate the table 'Demand' and 'Supply'
2. For the copied table, select the [Item], [Sub] column and unpivot the other columns.
3. Then merge them as a new table:
4. Expand Supply[Value] as [Value.1] and add custom column like:
5. then remove [value] and [value.1] and select the [Attribute] column to pivot the [Custom] column:
6. select [Aug-22] ~ [May-23] column and replace null to 0.
7. result:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data