Forum Discussion

ak77's avatar
ak77
Post Patron
2 years ago
Solved

SubTotal Adjustment for Matrix

Hi Experts, Please check and help on this if possible. I have the below Table display  and have the requirement as follows, 1. Do not change anything on Main Total  2.  Total of A , B , C from Cl...
Show and Tell
Tips and Tricks
Ahmedx's avatar
Ahmedx
Super User
2 years ago

why do you need to minus these two amounts? (141603149.23+-191498528.13=-49895378.90)

They don't have an ID so it's difficult.
you can add index column in power query?

 

ak77's avatar
ak77
Post Patron
2 years ago

Ahmedx , Sorry. thats the requirement from users.. and its the sum of those 2 values not minus..