Pivot Table Distribution Computation

[raceberos]

Hi Guys i have a challenge in computing the distribution in pivot table

im trying to compute the distribution rate from header to detailed but i always got wrong answer...

the GRAND TOTAL NET SALES(RETAIL+WHOLESALES) is okay coz if  but the GLDesc dont have any values to compute

it must compute

ex.

     Sales Concession Retail Fresh       3,737.00 / 32,062,031  so on....

thanks for the help

[sunny_talwar]

What is the expression for Jan... also, what are your dimension name in this chart?

[raceberos]

Hi mate good evening form my time zone

this is the formula for the Jan: Sum({<FinanceReportId={3}>} Value) * -1

i will upload the qvf file to refer on other dimensions.. !

thanks for the help

[sunny_talwar]

qvf file would be really helpful to see your issue

[raceberos]

Hi mate i already made it...

i use this formula

Sum(TOTAL {<FinanceReportContentId={73}>} Value) * -1

thanks for the help...