Hi, I've been publishing pivot tables for a while now with great success. However, today I wanted to publish the table that included a calculated column of information, i.e., fill rates. The formula in the spreadsheet is simple, divide the contents of one column by the contents of another column and format the result as a percentage. Easy, huh.
Well, now I want to add that column (fill rate) to the pivot table in the column drop area...works great. Now, publish the pivot table and, surprise, the fill rate column disappears. Everything else looks terrific, as before, but the new column, Fill Rate, vanishes!