Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Calcualted Item in Pivot Table

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?
Answers
-
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
0 -
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
0