So I have the following table of Discounts:
|Discount Name||Discount Category||Discount Amount|
What kind of formula will work to see the totals of the discount categories?
ex. I need to see Total Promotional = $88.75, and Total QSA = $34.50, etc....
I can do a portal for each category, filtered by each category, but that only really displays the number, I need a number I can use in further calculations.
Thank you in advance for any help on this...