Pivot table issue

[#1]

Hi, 

I am new to qlikview. Can you please help me to solve my issue. I am attaching .qvw file for your reference. In Table 1 values are showing correctly. In Table 2 (Though it is same except I have  replaced 'product' with 'revenue Repertoire' field in dimension. 

Your help highly appreciated. 

Regards,

Suhas

[rubenmarin · Accepted solution]

Hi Sushas, when showing by revenue the expression won't work because there are more than one value for fields like Relase Date.

If you want a sum of the products in each 'revenue Repertoire' one option can be tell qv to calculate the sum of each produt and YYYYMM using aggr(), in example:

Frontline: =sum(aggr(if (ReleaseDate <= MakeDate(Left(YYYYMM,4),Right(YYYYMM,2)) AND ReleaseDate >= AddMonths(MakeDate(Left(YYYYMM,4),Right(YYYYMM,2)),-11), sum({<[Source]={'SME'},[Prod Type Desc]={'RBT'},[Revenue Repertoire]=>}Quantity))/100, [Revenue Repertoire], Product, YYYYMM))

Catalouge: =Sum(aggr(if (ReleaseDate <= AddMonths(MakeDate(Left(YYYYMM,4),Right(YYYYMM,2)),-12), sum({<[Source]={'SME'},[Prod Type Desc]={'RBT'}>}Quantity))/100, [Revenue Repertoire], Product, YYYYMM))

Hope this helps.

[#3]

Thanks Ruben for your prompt response.