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
ak77's avatar
ak77
Post Patron
2 years ago

Ahmedx , Thanks for reply. i tried with actual dataset and it worked fine.. thanks again... but unfortunately one more issue has come.. The user has introduced a column record type on which total has to be taken.. for ex: The below 2 numbers of record type 'Total' should be added and displayed in main Total for selected effective date range

141603149.23+-191498528.13=-49895378.90 

Below is the report snapshot.The Main Total which is blank should have:-49895378.90 

 

The actual report is avaialble in below link.. Please please help ! let me know a new ticket needs to be thread for this

 

https://drive.google.com/file/d/14wMrb3AIg8y-zcmEEbAh7SKV3qX7AwT5/view?usp=sharing

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?