Hi guys, I have a question about fixed-calculation.
I have a column which called "group size", and each record saves that number.
I also have a column called "Total members" which is the same in all the records (for the same date).
I need to calculate "% of total" (but NOT by Quick Table Calculation - the total is bigger then the groups sum, there are a few groups I left out on purpose).
Which means: (group size)/(total members) ---> The problem appears when trying to calculate this on several groups SUM(group size)/(total members), How can I take just a single value to work by it?
Thanks a lot!!!
Did you try using LOD specifically FIXED? This will help keep the total members static. Also, please provide some data examples so that we can gauge the requirement correctly.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.