How to get Percentage column in measure of Pivot table

[whitestonek]

Hello Everyone, I have one excel column contains Percentage values.I want to take this column in pivot table as measure.Can you please suggest expression in qlik sense pivot table.

Sales Growth
127.7%
74.5%
-59.5%
126.3%
32.2%
64.2%
22.4%
67.0%
130.1%
122.3%
106.8%
35.4%

Thank you 🙂

[JordyWegman]

Hi Whitestone,

Why would you want this as a measure? You can insert this as dimension because the value is already calculated. If you do want this, you can use Sum([Sales Growth]. But when collapsed (the pivot table) you will get numbers that won't be correct.

Jordy

Climber