I need help doing a calculation in Tableau. I am looking for Personal Training Conversion percentage (PT/Total memberships). Total memberships contain all new Basic and all new Fitness memberships. I need to remove a dimension category from the all new Basic number (also a dimension). With in the Basic number any downgrades need to be removed.
1. the 290 contains downgrades that need to be removed and then I need to have the PTC% calculation. 40/290=13.79%. There were 36 downgrades so the calculated field should be where 290-36= 254 for a calculation PTC% of 40/254= 15.75% instead of the 13.75%. This needs to be applied to all clubs.
Could you please provide a sample mock up data in crosstab (.csv,excel,txt) or packaged workbook in .twbx format?