Forum Discussion

rajasekar_o's avatar
rajasekar_o
Helper V
2 years ago

SUB Total calculation.

hi Team ,
i need help  to calculate sub total.
data

expected output

i try but its showing 0 

 

 

 

Need Help

1 Reply

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi rajasekar_o 

    Please create a calculated column

     

    Category = SWITCH(
TRYE(),
Table[Column] IN {"Revenue from operation","Other income"},"A.REVENUE",
Table[Column] IN {"Cost of material","Purchase"},"B.Expense")

     

     

    Bring the Category column and existing column in Row
    and add the amount column in the Value of Matrix table
    You will get the output result



    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin