the excell attached is an extract of a qview pivot table, I would like make in the pivot table the same I made in column 'H' which is a simple quotient between each value of dimension TTOO and their nearest total amount.
By the way, I would also like to show only the TTOO representing the 80% of the total expression 'Prod', groupping the rest of TTOO in a summarized label 'REST OF TTOO'. Where should I touch to get this?
See attached example. If you don't have QV11 you won't be able to see the grouping since that uses dimension limits specific to QV11. You may want to change the Include Boundary Values option if the top 80% should not go over the 80% total.
See attached example. If you don't have QV11 you won't be able to see the grouping since that uses dimension limits specific to QV11. You may want to change the Include Boundary Values option if the top 80% should not go over the 80% total.
