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
%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.