I want to create a simple variance cell in a pivot table showing the difference between active rates. I can easily do this in Excel but I'm finding this difficult in Qlikview. I'm a new user so sorry if I'm missing an easy soluition.
Example table below:
|Good Claim Status||Poor Claim Status|
|Time Lapse||Element Active||Active Rate||Element Active||Active Rate||% pt diff (poor vs. good)|
Claim Status (include multiple categories) & Time Lapse are the Dimensions.
The %pt diif (poor vs. good) is the field I'm trying to calculate.
Thanks in advance