Calcualted Item in Pivot Table

Question

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?

EmmanuelMash · Answer

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

FTisiot · Answer

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