Pivot table not show year

[penpayom]

HI!

I don't understand ,why year in pivot table are '-' but  year in  table box  are value ='2015'

what should I do?

[arvind_patil]

Hi Penpayom,

Kindly check Year_ITEm has value against Year.

check show null value check box and check.

Thanks,

Arvind Patil

[mayankraoka]

Hi Penpayom,

Please attached sample QVW if possible.This will help us to answer your query faster.

Regards,

Mayank

[PrashantSangle]

What is your expression in pivot table???

[penpayom]

=sum(aggr(Fabric_QTY*(ITEM_CONTAIN/100),YARN_ITEM,Year))

How i can used [DISTING] in my this code

[PrashantSangle]

Why are you using AGGR()

try below

sum(Fabric_QTY*(ITEM_CONTAIN/100))

try this,

sum(aggr(Sum(Fabric_QTY*(ITEM_CONTAIN/100)),YARN_ITEM,Year))

Regards,