hello all how i can create new view on sql of revune total as shwen below
81102 202400320240331 L 000000000008203190D MYINV Store Name Cash
81210 202400320240331 L 000000000008211732D MYINV Store Name Visa
41113 202400320240331 L 000000000000099738D MYINV Store Name Visa Commission 12001 202400320240331 L 000000000000914000C MYINV Store Name Dine In - Beverage
11002 202400320240331 L 000000000000560300C MYINV Store Name Take Out - Food
12002 202400320240331 L 000000000000162000C MYINV Store Name Take Out - Beverage