Hello Everybody!
I have a column named Cancellations and a column of Total Appointments and wanted to create a column %Cancellations using the formula [Count Cancellation]/[Total] *100 but it is not giving me the expected percentages. If I just enter [Count Cancellation] as the formula it gives me a duplicate copy of the Cancellations column and if I just enter [Total] it gives me a duplicate of the Total column. I'm expecting to get a result such as 46.1 in the first row of the %Cancellations column but it's giving me 351.
Hi @Brian Adams
I don't know that you will be able to open the attached
this formula
sum({ FIXED [Prodline],[Bencat]:SUM([Count Kept])})/sum({FIXED [Prodline],[Bencat]:SUM([Total])})
will return this
in the workbook you sent
it looks like you tried to load your excel pivot table into tableau and it created a mess
Never load anything but raw data - let tableau do the work for you
tableau has excellent on line training - see https://www.tableau.com/learn/training/20212 it is a place to start and will take you from getting started through advanced calculations
Jim
