Sum of data not reflecting in pivot table - when the data is changing acc to the selection

[Anonymous]

Hi,

I have a pivot table where I have the expression as

(

(Sum(CF_AMT)-(sum(CF_AMT)*Per_Sales/100)) + Before((sum(CF_AMT)*Per_Sales/100),delay_Sales))

I have 2 slider objects to change the values of the 2 variables "Per_Sales" and "delay_Sales".

The value of the expression changes acc to the values selected for the variables BUT my problem is the TOTAL (using show partial sums) doesn't change acc to the values. It is fixed. I have used the before() function here.

Does anybody have a solution for this. Kindly help.

Thanks.

[Anonymous]

Hi,

Your per_Sales and delay_sales are not wrapped in an aggregation function (e.g. Sum/Min/Max) so QlikView will not know how to total/sum them.

Cheers.

Ad.

[Anonymous]

No.. it doesn't work

thanks for ur reply