How to get the total on product wise ?

[suvechha_b]

Hi All ,

How to get the total on product wise ?

see the screenshot.

sample attached.

[Anonymous]

Hi,

are you using pivot table?

Thanks,

Pooja

[suvechha_b]

yes

[Anonymous]

Ok, then go to presentation tab of properties and select Product from list and click partial sum and apply.

Thanks,

[suvechha_b]

Hi Pooja ,

Its already done .

please see the screenshot.

[Anonymous]

ok, Then go to expression and use num() before all calculation. may be here it considering all expression values as string . change value as num and check for the result.

[avinashelite]

Total is showing up rite ? check the partial sum on period and check