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 , Need a help on the solution provided ... MAIN TOTAL should exclude classification Total(38065) .so  MAIN TOTALshould be 16487+5718+15860=38065

Please check

 

    • 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?