Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
you need to change expression from sum to avg
try this:
if(rowno()=0, expressionyyy, expressionxxx)
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...
you can try range avg function
it will be easier if you post a small sample file:)
Thank you Pari Pari, the qvw is attached below.
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)
YOU must be use for modify a total the function dimensionality().
Bye marchetto
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 😉
Thank you Marchetto, I also tried to use dimensionality(), but I'm not able to make it work.
Any suggestion?
take a look at this....
let's start from the beginning:)
what you want to achieve in this selection (presented on attached screen)?