Dynamic Expression in Pivot Table

Wed, 23 Nov 2016 20:02:24 GMT

Hi Everyone,

I wish to achieve something depicted in the above picture.

The dimension on the left can be removed/added based on user selection through dynamic table field selection, so Dimensionality will keep changing.

I am facing issue in introducing the Achievement column highlighted in yellow. Achievment = Sales of 12 months/Goals of 12 months.

Can I insert an expression like this in pivot table? If I use a straight table, I cannot have pivoted headers for sales and goals.

Please help.

topic Dynamic Expression in Pivot Table in QlikView