running total with filter parameters and grouping

Hi, I need to display the running total for all the selected vendor order by descending total amount VENDOR ITEM AMOUNT VENDOR1 1 12,121.00 VENDOR1 2 12.00 VENDOR1 3 1,232.00 VENDOR1 4 12,312.00 VENDOR2 3 2,343.90 VENDOR2 1 123.00 VENDOR2 2 234.00 VENDOR3 1 123.00 VENDOR4 4 3,423.00 VENDOR4 2 123.00 VENDOR4 1 34.00 VENDOR4 4 3.00 VENDOR4 5 7,389.00 i need to arrive at these values TOTAL RANK RUNNING TOTAL VENDOR4 10,972.00 1 10,972.00 VENDOR1 36,757.00 2 47,729.00 VENDOR2 2,700.90 3 50,429.90 VENDOR3 123.00 4 50,552.90 the user has an option to select which vendor will be included using a slicer. Thank you for the help.