Pivot Table Total Error

aarnkalle — Mon, 18 Nov 2019 06:36:33 GMT

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'}>}))))

Re: Pivot Table Total Error

Arthur_Fong — Mon, 18 Nov 2019 08:22:10 GMT

You have a sample app?

AGGR() parameters should be :

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