2 Replies Latest reply on Feb 22, 2017 10:43 AM by EmmanuelMash

    Calcualted Item in Pivot Table

    choracy69

      Hi,

       

      I have problem with calculated item in pivot table.

       

      I created pivot table like:

       

       

      Where Quantity Shipped is a count on ma repair device and it's integer.

       

      Next I want to create percentage for two types from repair type. I use calculated item for this.

       

       

      It's working ok. But can I change data format for this two records on percentage?

      My calculated item looks like:

       

       

      Any suggestions?