Yes this is possible
Instead of A/B use sum(A) / Sum(B) in tableau where A and B represent your columns
This should give you the desired result.
If this does not work for you.
You can create the datasheet and the Total Line separately on different worksheets and place them on dashboard to imitate a single sheet.
Hope this helps let me know If you have any further questions
Thanks for your response. I can't do sum/sum because a = countd and b = count so it wont let me use aggregates on top of that. Any other clever ideas? Very much appreciate your help!
I forgot that when thinking of it. Do you have a sample workbook for this data.
if Countd(A) / Count (B) does not give you the total value
then you will need to create the total line on a separate sheet
So you would have
as measures on a second sheet without any dimensions to split the data
this will be your desired total value.
You can now place both sheets onto a dashboard to have it look like a single sheet.
If you have the raw data or a sample workbook I can help you achieve this.
Here is the raw data. Thank you!
Just to summarize, I need to be able to show subtotal for class a and class b and then company total for capacity (available seats) = countd(spot num), reservations = (count of uid), and then percent filled = reservations / capacity. The reason why (based on raw data) that capacity = countd of spot numbers is because we can possibly double book seats if something happens like a late cancel and some one on a waiting list takes that spot. So % full can be above 100%.
sample.xlsx 29.2 KB
Have a look at dashboard 1 in this workbook.
Clicking on class a or class b will change the grand total to show values for selection.
I have left grand total generated by tableau on worksheet1 so you can compare these to grand totals coming from worksheet 2.
Let me know if you have any further questions on this.
Book1.twbx 43.9 KB
Thank you so so much!! I sadly think the answer is I need to reorganize underlying data based on needs of how I need final dashboard to look.