Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I’ve been created the following pivot table and I’m knocking my head who to add a new column that will show me the relative value from the total.
below you can see the table that I created.
for example:
I like to take count(if(p=3,t)) / total count(m) - --- (both marked in red)
Thanks for your help.
Hi,
Do a expression like below for the new column
Count( if ( p=3, t ) )
/
Count( total m )
Rgds
Anand
Hi,
Do a expression like below for the new column
Count( if ( p=3, t ) )
/
Count( total m )
Rgds
Anand
thanks a lot.
Hi,
Hope you got correct or helpful answer from this if so mark it Correct or Helpful so other can see it.
Rgds
Anand
one more Q
how i calculate the difference between the bold columns in new column ?
date | S.regionname | hour | category | sum® |
2011-10-04 | A | 19 | 1 | 170,930 |
2011-10-04 | A | 19 | 2 | 17,673 |
2011-10-04 | A | 19 | 3 | 2,193 |
2011-10-04 | A | 19 | 4 | 3,051 |
2011-10-04 | A | 19 | 5 | 2,607 |
2011-10-04 | A | 19 | 6 | 40,812 |
2011-10-04 | A | 19 | Total | 237,266 |
2011-10-03 | A | 19 | 1 | 192,166 |
2011-10-03 | A | 19 | 2 | 28,836 |
2011-10-03 | a | 19 | 3 | 3,114 |
2011-10-03 | a | 19 | 4 | 2,928 |
2011-10-03 | a | 19 | 5 | 2,496 |
2011-10-03 | A | 19 | 6 | 5,625 |
2011-10-03 | A | 19 | Total | 235,165 |
Total | 472,431 | |||