I wanted to add a new row to this table, So that i am able to divide 4/7.
Like when i go under Analysis and use (Totals of - sum). A new row gets added with the total. I want to add a similiar row, but instead of the total, i want to return the value obtained by diving the upper two numbers. Here - 4/7
for this you need to make seperate calculation(Division Cals), & this seperate calculation can not be adjust just as a grand total.
so you need to manipulate your requirement.
Still Stuck Let me know
even if i create a new calculated field (Division cals). what function shall i write so that i get the desired output.
From the calculation perspective, this brings the expected results.
But from the view stand point, Tableau always need "dimension" to create table view and not easy to exclude "2018" from the table.
There are work around. but little bit troublesome.
members_SM_10.5.twbx 14.9 KB