Pivot Table Total Error

[aarnkalle]

i

Spoiler

Hi

I am getting error in pivot table and trying to use below formula but getting 0 value. Please help me where i am getting wrong.

(-sum(Aggr(Sum (Distinct ([QUANTITY] * [Unit Cost])),(distinct {< [SOURCE]={'Move order'}>}))))

+

(-sum(Aggr(Sum (Distinct ([QUANTITY] * [Unit Cost])),(distinct {< [SOURCE]={'Account alias'}>}))))

+

(-sum(Aggr(Sum (Distinct ([QUANTITY] * [Unit Cost])),(distinct {< [Transaction Type]={'HP Move Order Return'}>}))))

+

(-sum(Aggr(Sum (Distinct ([QUANTITY] * [Unit Cost])),(distinct {< [Transaction Type]={'HP Issue Expired Items'}>}))))

+

(-sum(Aggr(Sum (Distinct ([QUANTITY] * [Unit Cost])),(distinct {< [Transaction Type]={'HP Miscellaneous Issue'}>}))))

[Arthur_Fong]

You have a sample app?

AGGR() parameters should be :

aggr(<measures>,[<dimension1>,<dimension2>,etc])