Pivot table create additional measure for average

[#1]

Hi,

I would like to show on my pivot table as below:

Formula:

Sales/trx = Nett / Trx

18.83 = 5086.69 / 270

But i not able to get this results, any idea?

Message was edited by: Bryant Law Here i attached my qvf file

[awhitfield]

HI Bryant,

can you please upload your qvf?

Andy

[#3]

Hi Andy,

I did upload my qvf, check it out.

Bryant

[awhitfield]

Hi Bryant,

Change the Sales/Trx expression and the number format to as below as, and this is what you get you get this:

HTH Andy

[#5]

Dear Andy,

I still not able get it 18.84, could you upload your qvf.

Thanks.

Bryant

[awhitfield · Accepted solution]

Here you go!

HTH Andy

[#7]

I didn't aware the expression can have more than 1 aggregation...

[awhitfield]

Excellent, glad it's sorted 

HTH Andy