Using the summary number in beast mode
I have a data set that has invoice amount for each customer. I would need to create a card to show % invoiced for each client. % Invoiced to be calculated based on the total invoiced amount for all clients vs. the invoice amount for that client.
I have chosen the table view in the card and placed the client name and invoice amount columns. Have used the sum of invoice amount as summary number. Now i need to use the summary number in beast mode to divide the summary number with the invoice amount to get the % Invoiced.
I know how to do this in dataflow or sql query but i want to give an ability to the user to choose a date range or filter any of the clients and see the % invoiced. Is there any way that i can use the summary number in beast mode?