I am trying create a overage fee calculator that would let my firm compute how overage fee a subscriber will incur based on inputs such as the Quota used and the Total number of subscribers. I'll like to filter based on Plans users are subscribed to as well.

We usually do this in excel ( find attached) but we're now moving over to tableau and experimenting with this. I have recreated the data like I have in excel but when it comes to the dashboard I have difficulty translating this to allow a user to for example input a quota to see how much overage fee would be incurred or based on the sub count per month or at a particular point in time see how the overage fees change.

I can use all the help I get on this to create a concept for a dashboard. I'll appreciate any help or suggestion. The raw data is on Sheet 3.

The inputs fields are those highlighted in red. I want inputs for quota as well as input for subscriber count

The quota field can be derived from the table and is fixed per plan. If I filter by plan and the quota on that plan is say 250gig I want to see how their overage and other metrics change if the quota was to go up to 400 gig.

* subscribers = countD(mac ids

Avg Overage Fee = Total overage fee/ Total subs impacted

Monthly Initial ARPU Impact = Total overage fee/ Total actual subs

% Subs Impacted = Total subs impacted/Total actual subs

*Total subs = user input for anticipated number of subscribers

Total $$ Impact:( anticipated number of subs/ actual subs) * total overage fee

$$ Overage Fee per Usage Increment >Quota:

$ 10.00

Usage Increment per Overage Fee (GB):

50

*The overage fee per usage increment is fixed at $10 and usage increment per GB is set at 50G