how to know a total group import in a Pivot Table

[#1]

Hi

I need to solve this problem Total Rep Sales / Total Sales.

I try that:

I have this pivot table with two dimensions F1 - F2 and sum(F3) like expression with the chek show partial sum

I need to Know the value of Total in all rows, but i only have the value in the first row.

Thanks for all

[sparur · Accepted solution]

Hello

add NODISTINCT option in AGGR:

AGGR(NODISTINCT sum(F3), F1)

[#3]

Hi ,

Just tried this example as i am also interested in getting this solution for my application.

please see attached and kindly advice .

Bhushan

[#4]

Sorry Guys ,

I got my solution thorugh your discussion .

Please find attached

Thanks alot !!!!!!

Bhushan N

[sparur]

Hi, Brushan.

In what problem?