Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello
add NODISTINCT option in AGGR:
AGGR(NODISTINCT sum(F3), F1)
Hi ,
Just tried this example as i am also interested in getting this solution for my application.
please see attached and kindly advice .
Bhushan
Sorry Guys ,
I got my solution thorugh your discussion .
Please find attached
Thanks alot !!!!!!
Bhushan N
Hi, Brushan.
In what problem?