Pivot table avg

[Anonymous]

Hi,

using a pivot table I have this situation:

so I have total for both columns: I wouldn't have total for the second one but the average of the percentage.

Can I do it? How?

Thank you!

[#2]

try this:

if(rowno()=0, expressionyyy, expressionxxx)

[Anonymous]

Pari Pari ha scritto:

try this:

if(rowno()=0, expressionyyy, expressionxxx)

I tried

     if(rowno()=0, avg(VEN_PERC_SCONTO2)/100, sum(VEN_PERC_SCONTO2)/100)

but doesn't work...

[#4]

you can try range avg function

it will be easier if you post a small sample file:)

[Anonymous]

Thank you Pari Pari, the qvw is attached below.

[#6]

can you explain why

if(rowno()=0, avg(VEN_PERC_SCONTO2)/100, sum(VEN_PERC_SCONTO2)/100)

doesn't work? IMO works fine (see att qvw file)

[#7]

YOU must be use for modify a total the function dimensionality().

Bye marchetto

[Anonymous]

Pari Pari ha scritto:

can you explain why

if(rowno()=0, avg(VEN_PERC_SCONTO2)/100, sum(VEN_PERC_SCONTO2)/100)

doesn't work? IMO works fine (see att qvw file)

It doesn't work fine... (5+5+10)/3=6,67, not 5 😉

[Anonymous]

Thank you Marchetto, I also tried to use dimensionality(), but I'm not able to make it work.

Any suggestion?

[#10]

take a look at this....

let's start from the beginning:)

what you want to achieve in this selection (presented on attached screen)?