Calculated Item Problem

[ICE9]

I have added a calculated item to a pivot table, but i have several problems.
Rather than explain the whole problem, i will post what i am trying to do

The original table contains support ticket data

Pivot Structure

Row: Location
Column 1: Service Level (low, medium, high)
Column 2: Service Metric (pass, fail)
Data: Count of Tickets

What i need to show is the % pass for each Location/ServiceLevel
I do not want to show % fail

If i add the field to the data area, it shows both %pass and %fail. If I try to hide the %fail, then it also hides the %pass. Normally i would hide the column on the sheet instead of the pivot to resolve this problem. Unfortunately, there are more pivots on the same page, and the pivots will change when i refresh, so this is not an option.

So, instead I made a calculated item in the pivot table.
SD = Pass / (Pass+Fail)

Now, the problem is the number format.
If i change the calculated item to a % then it also changes Count(Pass) and Count(Fail) items to %.


This is highly frustrating, so any recommendations would be greatly appreciated.


As an additional note/problem. I cannot use a calculated item on the Pivot if another Pivot is based off of it's data. When i try to create the item Excel gives the error "Averages, standard deviations, and variances are not supported when a PivotTable report has calculated items". I must use the 1st pivot for all other pivots since there are 23,000 records and 18 pivots.

[ICE9]

I might as well add this addition request for suggestions while the topic is on pivot tables.

Does anyone know of a PHP pivot script for mySQL? So far i have only found two ways to make a pivot on the web.
1. Buy a $7,000 software plus $1,800 a year maintenance fee. (ouch)
2. Use mySQL/Access/OLAP/Mondrian/Jpivot/Java combination which is a royal pain since I would have to rely on all 6 apps working together to make a single pivot. (double ouch)