Strucked with sub totals in Pivot table on months

[#1]

Hi All,

I am new to QlikView , PFA

the Issue is when i clik on paricular month it is showing SUM of allocation value for the particular month but when i am selecting all the the months  the sum of Allocation Value is Not coming  for the months'

Can any one help on these,

Regards,

Sruthi Reddy

[stabben23 · Accepted solution]

Hi,

add month in your expression:sum(aggr(AVG(ALLOC_VAL),PRJ_NM,RSRC_NM,month))/8