Calcualted Item in Pivot Table — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Calcualted Item in Pivot Table

Received Response
11
Views
2
Comments
choracy69
choracy69 Rank 6 - Analytics Lead

Hi,

I have problem with calculated item in pivot table.

I created pivot table like:

pastedImage_0.png

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.

pastedImage_1.png

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

My calculated item looks like:

pastedImage_2.png

Any suggestions?

Answers

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    Hi @choracy69

    You can't because the number settings are applied to all the values of the same measure (your column in this case)

    An alternative approach could be to create different measures (one for each value of repair type) with a Filter statement.

    You could then create two measures "Irreparable %' and 'NFF %'.

    With all the measures clearly defined in the criteria tab you could set a different data format for the two percentages

  • EmmanuelMash
    EmmanuelMash Rank 4 - Community Specialist

    Hi

    This might be slightly different but it could help with visualizing how to reference data in a specific row and use it in a calculation:

    Calculating % change from values in one column

    Regards

    Emmanuel