Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

raceberos
New Contributor III

Pivot Table Distribution Computation

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

Distributionv2.JPG

4 Replies

Re: Pivot Table Distribution Computation

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

raceberos
New Contributor III

Re: Pivot Table Distribution Computation

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

Re: Pivot Table Distribution Computation

qvf file would be really helpful to see your issue

raceberos
New Contributor III

Re: Pivot Table Distribution Computation

Hi mate i already made it...

i use this formula

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

thanks for the help...

Community Browser